This is a discussion on ODBC error when connecting to SQL 7.0 from Access database within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi: I restored a SQL database to a new server and changed ODBC connection on the clients' machine. After ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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][NETDBLIB]ConnectionOpen[connect()),Connection failed...., I can open any linked tables in the Access database, just not certain forms, why? Would someone please help???? |