I used the WorkGroup Wizard (wrkgadmin.exe) to secure a access database. Now I notice every access database I try to access requires a username and password. What did I do wrong, and how to I drop the security I created?
I usually avoid it as well. Anyways, I found the problem. The pc I was using had left-overs from a 97 install, and 4 versions of the system.mdw file in 4 different locations. Once I found the right one, I removed the one user I added, and set the Admin password to "". That got me back in, but I still can't explain why it put premissions on all the database. Maybe because I used the wrkgadm.exe instead of the User Level Security Wizard?