I have an Access 2007 database with 3 diiferent types of users:
Administratrator: Has full control over all data and objects contained within the db.
User: Has full access to add/edit data but is unable to make system wide changes.
Guest: Has ability to view data only
I have a Security table that contains the username and a permission level for each person with an account on the db.
The question is, how do I apply the appropriate permissions to each user? As of right now, everyone can access all parts of the db.
The Administrator is fine to leave as it is.
Users need to be able to input and edit data using the forms in the db.
Guests need view-only access to the forms.
Please help!
Thanks,
Jamie