Convert existing table to linked table

[scottc_00]

I have an Access database (Origdb) that I want to split due to size.

I want to move several Large tables of RAW data (Table1 and Table2) to a separate database (Newdb) and do the applicable combining and querying in Newdb.


I will create Table3 and Table4 out of the queries in Newdb.

No problem so far.
Now that I have the Newdb I want to delete Table1 and Table2 from Origdb and
convert Table3 and Table4 in Origdb into linked tables which will import data from Table3 and Table4 in Newdb.

This is my problem.
Table3 and Table4 in Origdb have downstream dependencies that I don't want to rewrite.
I can easily create new linked tables in Origdb to the Table3 and Table4 in Newdb but then I have to rewrite my downstream queries in Origdb to use the new Tables.
If I rename the original table3 and Table4 the queries will still point to the old tables with the new name.
The only way I can think to do this is to convert the original Table3 and Table4 into linked tables.

Is this possible? Is there a method to do this where I dont have to rewrite all of my downstream queries to point to new tables.

Thanks

[ranman256]

that works fine. (i do this)
Create your external tables. Then link them back into your db.
It will not affect any existing code. The db still thinks they are part of the db.