ODBC Link Failure

[JoeGriffin]

Hi,
I have created a database program using Access 2000 that links to an
SQL server via ODBC. This program runs over a network and runs very
well. However, sometimes, I am getting an error saying "ODBC link
Failed". Does anyone have any idea why this is happening ?
Thanx

 

[Arvin Meyer]

Hi,
I have created a database program using Access 2000 that links to an
SQL server via ODBC. This program runs over a network and runs very
well. However, sometimes, I am getting an error saying "ODBC link
Failed". Does anyone have any idea why this is happening ?

Can't say for sure, but the overwhelming number of ODBC errors are caused by
permissions errors. See if there is a network limit on the number of
connections allowed.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access