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?
Allen in Dallas