Creating user level security independent of what Access provides

[brooksje]

I am looking for a good way to use password security and user level access control with an Access 2003 database. I got code that does a good job of creating a login procedure using a table of names, passwords, and levels of access granted to each user. The users now log in but so I need to get to the next step of controling which forms/reports users can open, and if possible which records they can view. I was hoping to store the login information on a form or in a table and then reference that when forms open to see that the user has the correct authorization, but I just don't understand how to do it and don't know if that is the correct way to approach this.

btw, I tried using Access's User Level Security Wizard and all that, but it doesn't seem to work well for multiple users using multiple PC's to hit a split database on a network drive especially if I want to get the control down to the record level.

Any suggestions are greatly appreciated.

Jeff

[puppydogbuddy]

see this link for a free security wizard add-in tool that will allow you to setup your own security mechanism in your Access application without having to implement Jet security.

http://www.accesswizards.com/Downloa...5/Default.aspx


3rd party commercial security software for Access (costs approx $50)
http://www.mindwarp-consultancy-soft...-download.html