How to set read-only for those linked table ?

  • Thread starter Thread starter Peter chin
  • Start date Start date
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.
 
Set the Recordset Type of the Query to "Snapshot".

HTH
Van T. Dinh
MVP (Access)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
"Read Only" Query 0
linking tables and relationships 3
Linked Table and Read Only Issue 1
Linked Table Bringing in Blank rows 4
How to link a Access FE to SQL Server BE 10
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Newbie: constrain data to only those in a second table? 8

Back
Top