I am using security in MS Access 97 for the 1st time. I had it set up good different people being able to access different forms and whatnot, but I had two big problems. The first one is how do I assign a password to a User other than Admin. Currently when I try to open the database I can use Admin as the name, and type in the password and it's fine. However when I try to sign in the user John Doe there is no password linked to it. If I type in the words John Doe and no password it works, how do I get a password associated with this user?
Also when I made a password with the admin everything was fine, except now that when I go to open another MS database I created, this too is asking me for the admin password. If I hit the clear password button in any of the databases it turns all the passwords off in all the databases on my computer. I want it so that one and only one of my databases requires a username and password to log in.
2007-08-16
04:35:59
·
3 answers
·
asked by
K-bo
2