convert tables to linked tables

[alan]

I have a database which is a duplicate of another database but with the
queries etc. modified. I want to now run the modified queries etc. on the
original database tables without changing that database. I simply wnat to
swap out the local tables for the linked ones. I tried to reaname but it
want's to delete relatuionsships. Will relationship exist to the linked one
now if I say OK?

 

[Rick Brandt]

I have a database which is a duplicate of another database but with
the queries etc. modified. I want to now run the modified queries
etc. on the original database tables without changing that database.
I simply wnat to swap out the local tables for the linked ones. I
tried to reaname but it want's to delete relatuionsships. Will
relationship exist to the linked one now if I say OK?

Yes. When using linked tables the only relationships (that matter) are in
the back end file. Any you create in the front end are merely for
documentation.

 

[alan]

Thanks, Rick, I made a copy anyways and itseems to work. Just checking I had
no repercussions.

Now I can leave the main db as the user entry and interactive query one and
the other as the weekly and monthly batch reports one.