In what way are Access tables linked with SQL server?
If the SQL server table is modified will it be automatically reflected in the [linked] table and when? Yes, on next refresh or requery.
If I edit the linked Access table will it be reflected in the SQL server table?
Yes; as before, these updates will be visible on the other end on next refresh or requery.
Trusted Connection only controls how the connection is made to SQL Server, not behaviour after a connection is made.


The key concept here is that linked SQL Server tables are truly linked to ACCESS, not copied. If you desire a private copy of the data, copy the tables down instead of linking them.