Allen Pitts
asked on
ODBC--Connection to 'DataSourceName' failed.
Good afternoon expert,
We have an Access database which is linked to
a MS SQL Server databse. The application works
fine for every one except a new user. When she brings up the application, when she submits he user name and password she gets
ODBC--Connection to 'DataSourceName' failed.
This error message is followed by another error message:
Microsoft Access cannot open the table in Datasheet view.
I have checked her ODBC connection in Control Panel
Administrative Tools Datasources (ODBC) and made sure that there is a System DNS exactly like the other users. There is a permission granted to all the users
in her Domain to the SQL server database but I went ahead and added her specifically. Still the same message.
Any ideas how to troubleshoot this?
Thanks.
Allen in Dallas
We have an Access database which is linked to
a MS SQL Server databse. The application works
fine for every one except a new user. When she brings up the application, when she submits he user name and password she gets
ODBC--Connection to 'DataSourceName' failed.
This error message is followed by another error message:
Microsoft Access cannot open the table in Datasheet view.
I have checked her ODBC connection in Control Panel
Administrative Tools Datasources (ODBC) and made sure that there is a System DNS exactly like the other users. There is a permission granted to all the users
in her Domain to the SQL server database but I went ahead and added her specifically. Still the same message.
Any ideas how to troubleshoot this?
Thanks.
Allen in Dallas
(Knee-jerk, Help Desk-like comment) Did you destroy and re-create the linked table, and try again?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.