Keeping user from updating FE data file

[Guest]

I have a very simple database used by 3 users at a time. It is split into BE
and FE. One user accesses the DB with queries only so I have created a DB
with the master file linked - and literaly nothing else, She will then create
and save all of her queries here. But - I want to keep her from accidently
updating the file. I can't seem to find a simple solution to simply not
allowing her to update. Any ideas? Thanks - Dika

 

[Joan Wild]

I have a very simple database used by 3 users at a time. It is split into
BE
and FE. One user accesses the DB with queries only so I have created a DB
with the master file linked - and literaly nothing else, She will then
create
and save all of her queries here. But - I want to keep her from accidently
updating the file. I can't seem to find a simple solution to simply not
allowing her to update. Any ideas? Thanks - Dika

You can accomplish this using Access User Level Security. Deny permission
to Update, Insert, Delete on the tables.
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555