Discussion Locked

Error messages in Access

0 helpful

7 replies

by nhughes79 Apr 30, 2001 last reply May 22, 2001

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

One of my users gets the following error messages when he tries to run queries within an access database:

'ODBC--call failed'

'[Microsoft][ODBC SQL Server Driver]Communication link failure (#0)'

The user is working from his own work stationtoo, so i would be very grateful if anyone could help

Kind Regards
Neil Hughes

7 replies

by krunch May 1, 2001

If I understand your problem properly, you are trying to access an SQL Server table from MS Access. If this is the case I have had good luck changing my connection to the SQL Server and my DSN to that SQL Server when it's something other than NamedPipes. To change the DSN to Named Pipes do the following:

1.Click Start, point to Settings, click Control Panel, and then double-click ODBC Data Sources (32bit).

2.Double-click the DSN that is generating the error message, click Next, clickClient Configuration, and then click Named Pipes in the Add Network Library box to select it as the network library.

3.Click Next, and then click Finish to save the DSN.