Remove Security

[Guest]

I have used the wizard to set up security and now want to remve all security
from my DB. How do I do this?

 

[Joan Wild]

I have used the wizard to set up security and now want to remve all
security
from my DB. How do I do this?

Depending on version, the wizard created a backup of your database (unless
you chose to decline). Look in the folder where your mdb is. You'll likely
see a file with the same name, but a bak extension. Rename that file to
have a mdb extension, and you're back in business.

Once you are certain you can open the file using the standard system.mdw
workgroup file, you can then safely delete the secure mdw you created when
you secured it.