Microsoft KB Archive/95053

{|
 * width="100%"|

ACC1x: Query Fails When Linked SQL Server Table Cannot Be Found

 * }

Q95053

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
When attempting to use an attached SQL Server table, you may receive the following error message:

Couldn't execute query; couldn't find linked table. Invalid object name .

  -or-

Unable to connect to data source.

CAUSE
The following two conditions are most likely to cause this error message:

  There is an incorrect entry in the [SQLSERVER] section of your WIN.INI file.

The [SQLSERVER] section of your WIN.INI file should look like the following example:

     [SQLSERVER] MYSERVER=dbnmp3,\\MYSERVER\PIPE\SQL\QUERY YOURSRVR=dbnmp3,\\YOURSRVR\PIPE\SQL\QUERY

This error is caused by an incorrect server name (MYSERVER or YOURSERVR) or extra spaces in the path.  The SQL database server is overloaded or unavailable.

RESOLUTION
Verify that the [SQLSERVER] section of your WIN.INI file has the correct entry for the server you are attempting to attach. Then check with the system administrator to see if the SQL database server is available for transactions, operating properly, and not overloaded.

Additional query words: kbtshoot tshoot

Keywords : kberrmsg kbusage

Issue type : kbprb

Technology :