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.

"Rick Brandt" wrote:

alan wrote:
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com