Linked SQL Table Can't Be Found

[OrWolf]

I moved my back-end Access tables to SQL and updated the links in the front-end to point to the SQL tables. When someone else attempts to use the updated front-end and open a linked table they get the following error message:

Could not execute query; could not find linked table.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.RA_SurveyRestriction'.(#208)

If the other user deletes the linked table and then creates the linked table on their own machine, the same table works fine. Any ideas?

 

[tlbroadbent]

Some things to check.

Are both of you using the same DSN to link the SQL table?

Is one of you using SQL authentication while the other uses a trusted NT connection?

Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm