Security Features on Access Database

[Juan]

Does any one know whether there is a way to allow people to look at a
database but restrict thier powers in terms of changing stuff. I want
my boss to change stuff but not other employees. I want to give access
to everyone with like a login feature and allow them to see reports,
tables, and queries but not allow them to change anything. Is that even
possible?

 

[Guest]

Certainly. There are two and a half levels of security in Access.

One is just using a database password. You need a password to get into the
database but once in you can do what you please so it might not be the ticket
for you.

Then there is user-level security where the database administrator can limit
who can do what by person or group. It's very hard to set up properly and
takes effort to maintain, but does the job. This is what you might need.

If your worry is people messing with forms and reports, you can also create
an MDE database which locks down the code. This does not prevent someone from
messing with the tables or data though. This is was I call the "half" and it
won't meet your needs.

One other possibility is to password protect the database for you and the
boss. Then create Data Access Pages for other users to view forms and reports
using a web browser.