I have a mdb file with lots of OBDC linked tables that are linked to the tables in SQL server elsewhere. I can not see any information on how they are "linked". It is a little scary not knowing whether an accidental key press will effect the live database.
If the SQL server table is modified will it be automatically reflected in the table and when? If I edit the linked Access table will it be reflected in the SQL server table? (Trusted_Connection=YES any significance?)