User level security

[madrappin]

I created a database with user level security, however, now every time I try to open any access file, it asks for a username and password. Even ones that I did not want to have any security on. Why did it do this?

 

[psemianonymous]

You have "joined" the custom workgroup file. You can "join" or "unjoin" workgroup files via the Workgroup Administrator. See my FAQ for details (and a better solution to joining/unjoining):

Explaining MDW files faq181-3950


For a general introduction/more material about how to really use Access/JET security, check the following excellent reference (not written by me):

http://www.abcdataworks.com/security.htm