I have an Access database that is using user level security. However, I have found that users who are not connected to the workgroup can get right into the database without a password. Since there are users who have admin rights to the directory I am forced to store the mdb file in and I have no control over whether or not they join the workgroup file these users can access the data when they should not. Also, I have not been able to find the workgroup Admin tool on XP to make XP users join the workgroup, so they have been able to get right into the DB. So, I have put a database password on the Access database which forces me to go through 2 login screens (since I am hooked to the workgroup) to get in to the database. More important, my VB code that uses the database can access everything fine that existed before the password was added, but everything after (like queries) it gets a permission error (even though the password has been added to the connection string!) So, I am at a real loss as to what to do to undo this chios. Any advise would be most welcome.

Meg.

It sounds like you have the same problem Quixote had. See http://p2p.wrox.com/topic.asp?TOPIC_ID=26935

If you correct that problem, you can remove the database password and you won't need the password on your connection string. Your permission error may be due to the fact that the user you're specifying in your connection string doesn't have the proper user level security permissions to the queries.

The workgroup Admin tool isn't related to XP. It's part of Access (Office). You can gain access to the Admin tool from the Tools|Security menu.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

That is most helpful. Thank you!

Meg.

I am having the same problem, but I tried what was suggested in the referred chain. I created new groups with the permissions as they should be then set the "Admin" & "User" groups to have no access to anything. Then I made sure the Admin user was only in the "User" group and just to be sure, I set each object to nothing for the Admin user. However, when I go to a users box who has Windows 2003 (I am on Windows 2000) and is not "joined" to the workgroup, they get right in! Still with access to all the data. I am so frustrated with the user level permissions I would really like to get rid of them. Do you know how I can "Unjoin" a group? Or turn-off user level permission and just use a Database password?