admin and access levels (1 Viewer)

[moose]

I am trying to put access levels on my database and was wondering if it is feasible to have a table with user names with an access level between 1 and 5 assigned to each user?
If so what would be the best way to go about it please?

 

[Pat Hartman]

You need a great deal more definition than that. Just creating a table with userID's and access levels is simple. What are you going to do with the access levels? To begin with the db needs to be secured so that users cannot possibly access tables either directly or via queries. All data access MUST be via forms. Then each form must "know" what its access level is and use that information in the Open event to either prevent or allow a form to be opened or to set the various data access properties properties. The forms may also need code in the form's BeforeUpdate event to prevent updates depending on the access level.