By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

SQL ODBC Error when idle

P: n/a
Got an odd one on an application, I'm using Access 97 to talk to SQL
Server (also we have 2002 and 2002 versions of the same application as
the client has many differant PC builds!!)
Just done the SQL conversion, all works well but if I leave the screen
open for more than about 30mins I get an "ODBC Call Failed" error pop
up when the form gets focus back, its as if the connection has timed
out. The last record is still there but has been saved, its as if the
connection has timed out after a period of inactivity???
Any ideas? The application recovers as it reconnects itself but before
that all the bound fields have the word ?#Error in them as of course
the bound record has gone
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more Microsoft Access / VBA Questions on Bytes