Linked SQL Server Tables in Access 2003

PScottH

New member
Local time
Today, 11:55
Joined
Apr 16, 2007
Messages
1
We are sharing an Access 2003 database amongst two departments that contains twelve (12) tables that are SQL Server linked tables. Nine (9) of the tables work just fine for people in both departments. Three (3) of the tables cannot be opened until the user refreshes the link(s) using their ODBC DSN.

We do not understand why nine of the tables work without issue but three will not.

Has anyone ever run into this issue before? Does anyone have any ideas on how to resolve this issue?

Thanks
 
Try breaking all the links, then recreating them all at the same time on those affected machines.
 

Users who are viewing this thread

Back
Top Bottom