General discussion

Locked

Error messages in Access

By nhughes79 ·
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

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Error messages in Access

by Krunch In reply to Error messages in Access

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.

Collapse -

Error messages in Access

by nhughes79 In reply to Error messages in Access

Poster rated this answer

Collapse -

Error messages in Access

by donq In reply to Error messages in Access

If answer #1 doesn't work verify the user has the proper SQL driver loaded on his/her machine.

Collapse -

Error messages in Access

by nhughes79 In reply to Error messages in Access

Poster rated this answer

Collapse -

Error messages in Access

by uellem In reply to Error messages in Access

IF he is working on a local Access database only (minus the SQL Server), remove the ODBC setup or try repairing the database.

Collapse -

Error messages in Access

by nhughes79 In reply to Error messages in Access

Poster rated this answer

Collapse -

Error messages in Access

by nhughes79 In reply to Error messages in Access

This question was closed by the author

Back to Desktop Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums