Linked SQL Server Tables in Access 2003

[PScottH]

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

 

[FoFa]

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