lock data in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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