lock data in queries

A

angie

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?
 
J

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.
 
Top