MS SQL Server ODBC - ODBC error when connecting to SQL 7.0 from Access database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ODBC error when connecting to SQL 7.0 from Access database

Enjoy988

2005-05-19, 3:23 am

Hi:

I restored a SQL database to a new server and changed ODBC connection on the
clients' machine. After that, users can login to the Access database which
connect to the SQL server via ODBC. But when they try to click on some
queries or open other forms, the login window apear again and won't accept
any login info. the error message is [ODBC SQL Server
driver]& #91;NETDBLIB]Connect
ionOpen& #91;connect()),Conne
ction failed...., I can open
any linked tables in the Access database, just not certain forms, why?

Would someone please help????

Sponsored Links