Link one-way only

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Once I set up linked tables in Access, is it possible to
prevent any changes I make to the records in these Access
linked tables from appearing in the source database? In
other words, I want the changes to the records in the
source database to show up in Access, but not the other
way around (ie a one-way link only!).

Thanks. Lisa
 
No, it's not possible. A linked table is a pointer to a table somewhere
else. When you make any changes to the linked table, you're actually
changing the original table.
 
Back
Top