Preventing data from being changed after running a query

[mkdrep]

I have some queries that pull data from one table and other queries that pull data from two related tables. In both cases, how do I prevent the data from being changed after the queries results are displayed? I know I could make a form and lock each field so it couldn't be changed, but I was hoping to avoid having to do that.....

thank you.

 

[Isskint]

Change the RecordSet Type of the query to Snapshot.

 

[mkdrep]

Change the RecordSet Type of the query to Snapshot.

Still new to this game.....where do I make this change? In the query itself?
thanks for the help....Mark

 

[Isskint]

In the query itself is the answer

Open your query in design view.
Click anywhere in the QDE (Query Design Editor) EXCEPT the grid.
Open the properties box and RecordSet Type is the 10th property.

 

[Simon_MT]

Personally I would not let users have access to Raw Queries. These should be put onto forms and use Read Only states Enabled and Locked Fields along with Allow Edits No Delete and No Add etc.

Simon

 

[mkdrep]

In the query itself is the answer

Open your query in design view.
Click anywhere in the QDE (Query Design Editor) EXCEPT the grid.
Open the properties box and RecordSet Type is the 10th property.

Worked like a charm! thank you very much

 

[mkdrep]

Personally I would not let users have access to Raw Queries. These should be put onto forms and use Read Only states Enabled and Locked Fields along with Allow Edits No Delete and No Add etc.

Simon

I appreciate the advice, Simon. I will keep that in mind.....