MAKING DATABASE READ ONLY

[Guest]

I have a HUGE database of information. Our office has several untrained users
who can access this database. Is there a way to make it read only for those
users (but not me) so that my sacred information is not tampered with.

 

[Rick Brandt]

I have a HUGE database of information. Our office has several
untrained users who can access this database. Is there a way to make
it read only for those users (but not me) so that my sacred
information is not tampered with.

You can use network permissions to make it read only for your users, but it
doesn't work to well if you want some people to be read only and others to
have full access and for them be in the file at the same time.

With that setup if the first person in is a read only user then ALL users
who open the file afterwards will also be stuck with read only access. If
the first person in has full access then read only users will be locked out
completely until that person exits the file. If you can work within those
limitations then using network permissions is the best way to go.

If you need different *simultaneous* access then you have to use Access User
Level Security (an advanced topic). ULS can be hacked by someone willing to
spend some money for a tool so it is not as secure as using network
permissions.