Linked Tables

[Guest]

I have two databases - call them DB1 and DB2

- In DB1 I have a table called "offset"
- In DB2 I did the following: File>Get external Data>Link tables. I linked
it to the DB1 "offset" table.

In DB1 I have a delete Query executed by a Macro which is deleting the data
from DB1 "offset" table.
Why do I still have data in the DB2 "offset" table after I ran the Macro -
the Tables are linked, should it not be empty as well after running the Macro?

Thanks
Klaus

 

[Pieter Wijnen]

You're absolutely sure you linked it (and to the correct version of DB1),
and didn't import it?
Linked tables have a little -> in front of them

Pieter