convert tables to linked tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
alan said:
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?
Click to expand...

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.
 
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.
 
Back
Top