Read Only query

[Bob B]

I want to display a query and have it be read only, no updates or adds.

 

[Douglas J. Steele]

Try changing it to a Distinct query, either by going into the query's
Properties when you've got it in Design View and setting the UniqueValues
property to True, or by going into its SQL View and change SELECT to SELECT
DISTINCT.

 

[tina]

suggest you bind the query to a form, and set the form's RecordsetType to
Snapshot.

hth

 

[Bob B]

This works just fine since I'm using the query in a form.

 

[Bob B]

This does work if UniqueValues is set to yes

Try changing it to a Distinct query, either by going into the query's
Properties when you've got it in Design View and setting the UniqueValues
property to True, or by going into its SQL View and change SELECT to SELECT
DISTINCT.