Security Settings - Why is it set for ANY database opened

[TJones76]

Hi!
I'm a new one for setting up security features in a database. I've set up group level security on a database and it works fine on my computer, but now I've got two problems:
1.) When opening the database from another person's computer, it opens in Admin role...does not ask for any logon information and,
2.) Every time I open Access or any database on my computer, it asks for logon information.. I only wanted the security set up for that one database.

What's up w/ that????

Thanks!!
Tiffany

-Tjones76

 

[lupins46]

I'm afraid you have a lot of reading to do.
The security FAQ is here. Give yourself a few days to get to grips with it.

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793

Access uses Workgroup security. Usernames and passwords are held in a workgroup file (xxx.mdw). Once logged in, the individual user or group permissions are held in the database file (yyy.mdb). When you invoke the login dialog by setting an admin password you are doing this for the Workgroup you are attached to at that moment. Any use of Access while you are joined to that workgroup requires you to login.
Since you did not refer to the workgroup file in your question, I assume that you have used the deafault workgroup file on your local pc to set the admin password.

When you go to a different pc it will be using its own workgroup file which has not been set to require a login.

But as I say, Access security requires a goood deal of reading and practise. Make sure you have a good unsecured copy of your database to fall back on.

 

[TJones76]

Thanks Lupins46...
Yeah this is my first attempt at securing a database.. what you said makes sense as to why it's not working... man it would be so much easier if someone could just show me how to do this step by step and explain the "whys". I'll read up on the info in the link you provided.

Thank you so much!
Tiffany

-Tjones76