I have a user that was just given a new windows 7 computer. I have a database that has linked tables to an SQL 2005 database that I administer. The database is an Access 2003 database. The user is using Access 2010. whenever I use a linked table I get the SQl Server error 1801. I have added the ODBC connections on the users PC. Whenever I try to delete and and a new linked table I get the error message. I added the user as a new connection to the database with windows authentication but this did not resolve my issue. Any help is appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.