Removing Security

[PowerPoint Jedi]

Well I was playing around with the security features as I wanted to secure
one of my Access databases.

Now whenever I open a previously created database or try to create a new
database it forces me to login.

How do I turn this off for all databases.

Note this is only local to my computer other people can open those databases
without a login requirement.

I am using Access 2003.

Thanks

 

[Chris O'C via AccessMonster.com]

Rejoin the default workgroup (named system.mdw) and use a shortcut for each
secured db (all one line):

"path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw"

Any time you open a normal Access db, you aren't prompted for user name and
password. Any time you need to open a secure db, you use the shortcut, which
will prompt you for your user name and password.

Chris
Microsoft MVP