Linked Tables (to SQL Server)

[DBAMJA]

I have about 20 linked tables. 18 of them are linked to one SQL database and 2 are linked to another SQL database, both residing on the same server. I have them linked using two different ODBC connections since they are two different databases. The problem that is happening is that the tables that are linked first get the error 'Invalid object name'.

Any ideas to get around this?



[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[dhookom]

When/where/how do you get the error message? I think you should be able to maintain links to data from multiple different sources without experiencing issues.

Duane
Hook'D on Access
MS Access MVP

 

[DBAMJA]

Even just trying to open the table just to view the data, I get the error.

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[dhookom]

What have you tried? Did you attempt to relink the tables?

Duane
Hook'D on Access
MS Access MVP

 

[DBAMJA]

I've tried relinking them, setting up new ODBC connections, etc.

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[dhookom]

What are the names of your tables on the SQL server? How about unusual field names?

Duane
Hook'D on Access
MS Access MVP