Lock records in query

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

Guest

I have a three table DB and i have created a query that shows all records
from the three tables. How do i make it that the query can only be viewed and
not edit?
 
In query design view, open the Properties box.

Making sure you are looking at the properties of the query (not of a table
or a field), set:
Recordset Type Dynaset (Inconsistent Updates)
 
Hi,
open the query in design mode, click on View-->Property then change the
recordset type in Snapshot

bye
 
I tried using this record set and though i was sure it was through the
properties of the query it still allowed me to edit the fields. Is there any
other way?
 
Running query in snapshot prevented the edit. Is there a way to remove or
hide the tool bar so user can not undo the properties of the query?

giorgio rancati said:
Hi,
open the query in design mode, click on View-->Property then change the
recordset type in Snapshot

bye
--
Giorgio Rancati
[Office Access MVP]

acss said:
I have a three table DB and i have created a query that shows all records
from the three tables. How do i make it that the query can only be viewed and
not edit?
Click to expand...
Click to expand...
 
Back
Top