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
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
Comment