ODBC Call Failed

N

NAS

Whenever I run certain queries in my database, I get an ODBC call failed
error. This seems to happen at random, on random queries. In some instances I
will successfully run a query only to run the same query again and have it
fail. I am using Access 2003.
 
S

Shane Cousineau

I am having the same issue's in both Access 2003 and 2007 DB's. it seems if
the user does not perform any actions in the DB for a period of time (i have
it somewhere between 2-5 minutes still trying to pinpoint the timeframe)
then the DB's will time out the ODBC connection. However if the user is
working in the DB without break then it never occur's. Due to a slow down
in business my user's are not doing as much as before and this is now
occuring frequently. If anyone has a workaround other then closing and
re-opening the DB (which is the only thing i have found to fix the issue) I
would love to hear it.
 
P

Pieter Wijnen

has to do with timeout settings. google for odbc timeout.
Also make an error trap to give the results of DAO.Errors(0).Description
when you've encountered an ODBC error
(immediate window or in code)

pieter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

call failed 1
MS Oracle ODBC failure in Access 07 3
ODBC--call failed. 2
ODBC - call failed 2
3146 Error, and Invalid Argument Value error 2
ODBC--call failed. SQL0666 - Estimated processing time exceeds li 1
Pass-Through ODBC query *to* (not from) MS Access 4
Using "like" query from and external link to Access 1

Top