Locking queries - datasheet view

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

Guest

I don't know if this is possible, but I currently have a form that has a command button that generates a query in datasheet view

I'm wondering if there is any way I can lock the records in the query datasheet view so that no changes can be made

Or would I be better off changing the query's values into a form or a table

I want to be able to lock the records so the user cannot accidentally change the data

Thanks in advance
Matt
 
I don't know if this is possible, but I currently have a form that
has a command button that generates a query in datasheet view.

I'm wondering if there is any way I can lock the records in the
query datasheet view so that no changes can be made.

Or would I be better off changing the query's values into a form or
a table?

I want to be able to lock the records so the user cannot
accidentally change the data.

Thanks in advance, Matt
Click to expand...

DoCmd.OpenQuery "QueryName", , acReadOnly
 
Hi

Alternatively, go into the query design, right click on
the grey background and open up Properties from the
resulting menu, and change 'RecordSet Type' to 'Snapshot'.
This will make the query results totally read only every
time it is run.

Cheers

David Cleave
-----Original Message-----
I don't know if this is possible, but I currently have a
Click to expand...
form that has a command button that generates a query in
datasheet view.
I'm wondering if there is any way I can lock the records
Click to expand...
in the query datasheet view so that no changes can be made.
 
Back
Top