Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
anyway i can lock the information in a query?
- Thread starter sunspot11
- Start date
sunspot:
If you must use the datasheet view of the query just set the query type to Snapshot.
In the query design window, bring up the proerties window and right click in the empty area in the upper window. The properties window should say Query Properties. On the Recordset Type line select Snapshot and save your query.
When the query is opened, no one will be able to change data. Of course if others have access to the query in design mode they can easily change this back.
HTH,
Vic
If you must use the datasheet view of the query just set the query type to Snapshot.
In the query design window, bring up the proerties window and right click in the empty area in the upper window. The properties window should say Query Properties. On the Recordset Type line select Snapshot and save your query.
When the query is opened, no one will be able to change data. Of course if others have access to the query in design mode they can easily change this back.
HTH,
Vic
- Thread starter
- #4
- Status
Similar threads
