Joins do not differentiate between local & linked tables; they are based
strictly on the table name, so you should have no problem. The queries,
forms, & reports won't know the difference as long as the table name stays
the same as the local name for the linked table. The only relations that are
broken by such a move are the direct table-to-table relations (and associated
referential integrity) in the Tables -> Relationships window.
Just remove the link, then copy the table from the foreign db and paste to
the local db, giving it the same name as the original link.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
