"SQL Server does not exist or access denied"

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

I keep getting the error "SQL Server does not exist or access denied"
whenever I open a form in an Access database.

I know *why* it's happening - one of our servers is down - but I can't find
any reference to this database server in the Access database. The Access
database relies completely on another database server which is running fine.

I tried putting a break in the code to step-through until it tries the
connection, but the error seems to happen *before* the first line of code
executes.

Any ideas how I can find out where the Access database tries to connect to
the server that's down?

The exact message is:

Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
 
If it is an MDB front-end to a SQL-SVR db, then it is quite possible that
there is one table (even a hidden table) which is linked to a different
server. The easy way that I know to find it is to try openning each table.
The bad one should fail. The other possibility is to open each table in
design view and right-click on the title bar and choose properties. The
Connect Property is the one which will show. Also have a look at the
following url:

http://www.mvps.org/access/tables/tbl0012.htm

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Querydefs can also be directly linked to ODBC
connections, as can the SQL behind forms, combo boxes,
or list boxes.

After checking the tabledefs, if you still have a form that is failing:

1) Check the Record Source property of the form.

2) Make a backup copy of the form or database.
3) Set the 'has module' property to no.
4) Retest
5) Delete any subforms
6) Retest
7) Delete controls one at a time and Retest

(david)
 
Back
Top