Link to home
Start Free TrialLog in
Avatar of Allen Pitts
Allen PittsFlag for United States of America

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
 

Avatar of Jim Horn
Jim Horn
Flag of United States of America image

(Knee-jerk, Help Desk-like comment) Did you destroy and re-create the linked table, and try again?
ASKER CERTIFIED SOLUTION
Avatar of Jokra_the_Barbarian
Jokra_the_Barbarian
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial