Make queries read only?

  • Thread starter Thread starter Chuck Arbogast
  • Start date Start date
C

Chuck Arbogast

Hello,
I am using code to create a query based on user inputs. What I want to do
is create this as a read only query. I want to use code to do this.

Any help is appreciated,
Chuck
 
Try setting the query's RecordsetType property to Snapshot:

CurrentDb().QueryDefs("Query1").Properties("RecordsetType") = 2
 
Hello,
I am using code to create a query based on user inputs. What I want to do
is create this as a read only query. I want to use code to do this.
Click to expand...

One sneaky but effective way is to set the Unique Values property of
the query to True (include the primary key or some other unique field
in order to see all records).

If you're opening the query in code, use dbSnapshot instead of
dbDynaset.

John W. Vinson[MVP]
 
Thanks for all the help but I figured out my own question. For anyone
interested here is the line of code that made this happen:

DoCmd.OpenQuery "QueryName", , acReadOnly
 
Back
Top