Search results for query: *

It's a date/time column. But - I rewrote the darn thing to just use the form in subsequent queries & the report, instead of trying to load the dates in a table. The rewrite works fine. Thanks for your help on this, it's really great to be able to ask questions and get solid answers. I...

Tried your code, now I get "ODBC - data out of range" if I run it as a select query, and "[Microsoft][ODBC driver for Oracle]Error in column1:Datetime field overflow (#0)" if I run it as a make table query. When I run my original code, it selects the records from the...

The SQL code that's generated is: SELECT DISTINCT [startdate] AS StartDateTest, [endate] AS EndDateTest, EMPAC_EWM_WO_AUDITS.DATE_TIME INTO tblTestDates FROM EMPAC_EWM_WO_AUDITS WHERE (((EMPAC_EWM_WO_AUDITS.DATE_TIME) Between [startdate] And [endate]));

I am converting from 97 to 2000. I am having trouble with a make table query that contains a prompt (for start date and end date) and puts the data in a new table. It works fine in 97, but in 2000 it returns an error that states "... can't add all the records in the update or append...

Also, use regedit.exe and look at: \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\ODBC There are parameters for LoginTimeout, QueryTimeout, and ConnectionTimeout that you can change to increase the defaults.

I fixed the problem by downloading and installing Jet35SP3. Now my query works.

There are 4 people that have tried to run this single query from the same Access data base; 3 of them are on Access 97 R1, one is on R2. They all log into the same Oracle data base using the identical ID and password. (We are all developers / system administrators). The SQL view in Access...

I run a query in Access to an Oracle 7.3 data base and get ORA-00960. The person in the next cubicle runs it on his PC, and does not get the error. We turn on Tracing, and my sql.log file contains: fff9c8bb:fff9ce1b EXIT SQLExecDirect with return code -1 (SQL_ERROR) HSTMT...