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.