ODBC Link Failure

  • Thread starter Thread starter JoeGriffin
  • Start date Start date
J

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
 
JoeGriffin said:
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 ?
Click to expand...

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
 
Back
Top