update one table from a linked table?

[gbshahaq]

this might seem a really stupid Q but:

I have one table of employees in an Access 2000 db.
I have an (almost) identical table which is linked from a 97 ver db.

For performance reasons I want my queries to use the non-linked table, but for compatibility (and other) reasons, i need the 97 table to be the "master".

How to keep the non-linked table consistently the same? I tried an update query but this only changed existing values - did not add new ones.
Pls help...

Sham

 

[gbshahaq]

silly me - should have read this:

(not-so-nicely-presented) info from MS themselves

found this from the Queries forum....