Not allowing LINKED data to be updated

[Dika At Work]

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 from here. I can't seem to find a simple solution to simply not allowing her to update. Any ideas? Thanks - Dika

 

[Pat Hartman]

You will need to implement Access security to prevent updates to the table or anything else. Before you start you MUST do two things.
1. Back up your database and then back it up again.
2. Read the Security FAQ and follow it EXACTLY. Here's a link to it: http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp#_Toc493299666

 

[Dika At Work]

Pat - thanks for your reply. I am going to stay away from setting security due to the work setup here. I am part time, and we have problems enough without trying to password anything. But again, thanks. Yours Dika

 

[IgorB]

Make all tables hidden and they will be not visible for users, it is not elegant solution but could help you.

Igor