Lock the query

  • Thread starter Thread starter elli
  • Start date Start date
E

elli

Hi there
How do I lock the query so that the user's vcannot change the fields on it?
Simple I think but too much for this newbie...

-elli-
 
Easiest way would be to make it a Distinct query.

Either check the query's Properties and set its Unique Values property to
True, or else go into the SQL view of the query, and change the initial
SELECT to SELECT DISTINCT.
 
Hi there
How do I lock the query so that the user's vcannot change the fields on it?
Simple I think but too much for this newbie...

-elli-
Click to expand...

i assume you mean so the user cannot change the 'data' in the fields.

Right-click on the upper portion of the query grid in Design View.
Select Properties.
Set the query Recordset Type property to Snapshot.
 
Thank U both!!

-elli-



fredg said:
i assume you mean so the user cannot change the 'data' in the fields.

Right-click on the upper portion of the query grid in Design View.
Select Properties.
Set the query Recordset Type property to Snapshot.
Click to expand...
 
Back
Top