Read Only query

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

Guest

I want to display a query and have it be read only, no updates or adds.
 
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.
 
suggest you bind the query to a form, and set the form's RecordsetType to
Snapshot.

hth
 
This does work if UniqueValues is set to yes

Douglas J. Steele said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Export query to Excel use data from the query as part of file nam 5
"Double hop" problem 4
can't update--object read only 1
Word template merge from Access 4
Defaulting to SNAPSHOT recordset for Linked Tables 4
Counting multiple memberships 1
Modify Parameter Query 1

Back
Top