By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Creating user level security independent of what Access provides

P: 1
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
Oct 27 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
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
Oct 27 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.