how to avoid accidental changes to table

[tom mitchell]

I have a database set up as a table. I created a few queries to run
for specific info based on the underlying table.

Is there any way to make the queries read-only? My preference would be
to have all data in the table secure and only affected if I wanted to
add or change anything. Otherwise I would access the info via
queries, filter to my heart's content without being afraid of
accidentally losing some info.
I read up on lock but this seems only to prevent others to access the
data while I am working on it, does not safeguard against my own
mistakes.

Any suggestions are greatly appreciated
Kind Regards
Tom

Please post to this newsgroup

 

[tom mitchell]

John,

Thanks for your suggestion. Unfortunately, I am not that experienced
with Access and can't quite follow your advice.
To be honest, I don't even understand what the unique values really
do. Reading the help file, it appears that it will only show up unique
values when doing a query. As my database contains names and
addresses, that would not work. Many people do show up with the same
city and therefore would be lost? . Do I miss something?

Kind Regards
Tom

One sneaky way is to set the query's Unique Values property to True
(in SQL, it's SELECT DISTINCT). If you include the Primary Key in the
query, all records will already be distinct, but the property will
make the query read-only.

Kind Regards
Tom

Please post to this newsgroup

 

[Van T. Dinh]

1. Open the Query in Design View.

2. Open the Query Properties window (make sure it is the Query Properties
window and not the Field Properties window).

3. In the "Recordset Type" row, select "Snapshot" which will make your
Query a snapshot, i.e. no additions, deletions or edits.

 

[tom mitchell]

Thanks a lot - just what I was looking for, works perfectly
Tom

1. Open the Query in Design View.

2. Open the Query Properties window (make sure it is the Query Properties
window and not the Field Properties window).

3. In the "Recordset Type" row, select "Snapshot" which will make your
Query a snapshot, i.e. no additions, deletions or edits.

Kind Regards
Tom

Please post to this newsgroup