Microsoft Access Security question?

Question

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.

Answer 1

The above answer is good. Basically you need to create a workgroup file (*.mdw), and then execute the database through a shortcut that references that workgroup file.

Also, you need to make sure that the default "Admin" user is only assigned to the "Users" group and not the "Admins" group. Then you need to make sure that the default "Users" group has no permissions to do anything. This will remove all default access to the database. Of course you will need at least one user assigned to the "Admins" group so that you'll be able to make changes in the future.

Most of the stuff is done under the Tools => Security option, and the "user level security wizard" is helpful for getting the process started. It will create an unsecured backup of the database in case something goes wrong, the workgroup file, and a shortcut that opens the database with the workgroup file called as a command line option.

I don't remember if Access 97 has the security wizard, you may want to think about upgrade?

Good luck.

Answer 2

Well you got to remember that MS Access was designed to a be a "personal" database. Hence it has one centralized login for the admin. However it has grown a bit to handle more than just admin but it is kinda a lengthy process. The link I have specified below will show you first how to create account groups and then create user accounts to assign to the various groups.

Enjoy!

Answer 3

If that get right of entry to report is from a primary source, then Open it. you notice, the warnings won't stop on account that get right of entry to could desire to contain a nifty script which could do stuff that may additionally assist you... For you, that is purely a warning and you gets this each and every darn time. confident, it relatively is in simple terms like the boy who cried WOLF. ultimately, you get desensitized by employing all of it, and completely ignore with reference to the warnings... THEN WHAMMO, somebody sends you an outbreak contaminated get right of entry to report; or script that whacks your pc. so which you are going to be able to desire to grow to be clever approximately the place it comes from. good luck and chuffed Computing!