lock data in queries

[Guest]

i want to "lock" a query in a database in order not to be able to
change/delete/add data when i run the query.

could that be achieved?

 

[John Vinson]

i want to "lock" a query in a database in order not to be able to
change/delete/add data when i run the query.

could that be achieved?

Set the Query's RecordsetType property to Snapshot.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[John Spencer (MVP)]

Yes.

One way, is to open the query in the query grid and set its recordset type
property to SNAPSHOT.

Another is to use a totals query and include the primary key so every records is shown.

Another is to make every field a calculated field, by concatenating a
zero-length string to text, multiplying by 1 for number fields, etc.