Re: Technical questions
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 07/02/04
- Previous message: anonymous_at_discussions.microsoft.com: "Access equivelant"
- In reply to: eNerGiZer1010: "Technical questions"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 02 Jul 2004 23:01:03 +0200
On Fri, 2 Jul 2004 07:40:29 -0700, eNerGiZer1010 wrote:
>Hi folks,
>
>I have a project underway and am having a couple
>technical difficulties. My duty is to run my access
>database with sql server.
>
>My fist problem is for table jobs.
>If I want to delete a certain number of JobId's what do I
>have to write in the criteria. For example if I want to
>delete IdJobs 19 750 to 19 760. What is the function that
>will do so. What do I write in the criteria.
>
>My second problem has to do with the query's.
>I have a large number of lignes (enregistrements) that I
>have to query. From what I heard the is a limited number
>of lines allowed per query. How can disable that feature
>to have unlimited lines for every query?
>
>Finally my last problem is much more technical for you
>sql wizards. I have a script to automate a query in
>access. What I have to do is configure the script to be
>compatible with sql server. So far it hasen't been that
>easy. When I run the script it's giving me the error that
>code 80040E21. The line is the following:
>
>Else
> oRS.Open "Select * from AlertHistory Where Date
>=#"&DateValue(LogTimeStamp)&"#;",oConn
>
>What I think is that maybe the date format is not the
>same because what I need is yyyy/MM/dd.
>
>Could a genius figure this out. I need to run the script
>to do a query in sql.
>
>Thanks for all the help.
>
>
>Cheers!!!
Hi Energizer,
Already answered in microsoft.public.sqlserver.programming. Please don't
multi-post.
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)
- Previous message: anonymous_at_discussions.microsoft.com: "Access equivelant"
- In reply to: eNerGiZer1010: "Technical questions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|