Access 2000 Database drops SQL connection daily

[Guest]

I have two users who have an Access 2000 database which connects to SQL
server for queries, and the users report that every time they open the
database they have to re-establish the connection, it won't stay connected.
The users were originally on Windows 2000, and were recently upgraded to
Windows XP, they have had the problems ever since they were upgraded. The
connections are mapped as File DSN's. FYI, I tried re-creating the
connections as System DSN's, but got an error message regarding Microsoft Jet
Admin cannot access the ADO object. Any suggestions on how to correct the
problem would be appreciated. Thanks!

 

[Guest]

I don't know if any of this will help, but you might want to look into it....

(ACC2000 How to Set the QueryTimeout Value for ODBC Connections
http://support.microsoft.com/?id=208386

Supported data sources for importing, for exporting, and for linking in an
Access database project http://support.microsoft.com/?id=830797
From paragraph 3:

"To permit Access to successfully transfer text data or to successfully link
text data to Microsoft SQL Server, you must increase the QueryTimeout value
in the registry, or you must disable the ODBC Timeout by setting the value to
0 (zero).

The following registry key controls the QueryTimeout value:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\ODBC\QueryTimeout "


(ACC2000 OpenDatabase Method Does Not Use Jet LoginTimeout
http://support.microsoft.com/?id=202037

Note: I added the parentheses around the "ACC2000:" in the titles of two
articles. The reason is that these KB articles should apply equally well to
Access 2002 and 2003.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks for the assistance, so far so good! I appreciate it.

 

[Guest]

So far so good sounds pretty good to me! Let's hope it continues working
properly. Thanks for reporting back.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________