Database refresh kills my ODBC connection.

J

Jim Moberg

I report off of a database that is a backup of our production database and
it's updated with new data every 10 minutes. If I am in the middle of
running a query when the refresh occurs I loose my ODBC connection. Then I
have to shut down Access and start it up again.

Is there any setting in Access that can allow it to maintain it's ODBC
connection while the refresh is occurrning?
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
ODBC connection drop 0
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
VBA ODBC Connection with 32bit and 64bit systems 2
MS Oracle ODBC failure in Access 07 3
ODBC Linked tables keep on getting error 3151 5
Bulk Change ODBC Link 5
ODBC Connection through Access VBA using Windows 7 1

Top