Lock records in query

A

acss

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

Allen Browne

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)
 
G

giorgio rancati

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

bye
 
A

acss

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

acss

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