How to set read-only for those linked table ?

P

Peter chin

Hi, guys,

Any ideal how to set this to limit the user for only perform its own data
query not to change the data.

I has test to change the data in query for those linked table after that i
find it change the table data as well.

Please assist.....

Peter.
 
V

Van T. Dinh

Set the Recordset Type of the Query to "Snapshot".

HTH
Van T. Dinh
MVP (Access)
 
Top