Referring to "real" table names

[kalebson]

I have 2 different databases both with the same table names for our 2 locations. I am linking to these tables in my access database I have to rename these tables in order to have them both linked in the database. Is there a way to make Access understand that the renamed tables real name is "BLAH"? I want to set the connections string property for these tables so that I dont have to login in every time but when I do it says it cant find "BLAH BLAH" table because I had to rename it. Or is there a way in the connection string or relationship area to show the real table name? TIA

 

[rjoubert]

I have to rename these tables in order to have them both linked in the database.

Actually, you don't have to rename them. If you link to "MyTable" in both source databases, the first one you link in will be called "MyTable" and the second one will be called "MyTable1." If you added a third, "MyTable2", etc.

 

[kalebson]

Yeah I tried that just linking to them and letting access name them however it them says cant find "MyTable1" when I try to query from it using the ODBC connection string. The one just called "MyTable" works fine.