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

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


PowerPoint Jedi wrote:
Show quoteHide quote

Securing divided database using workgroup (*.mdw) file
security.mdw from h drive to network
Securing a database
Passwording, and Read-only
add trusted location
VBA codes
Multiple Users
Security on individual records
Give Full access to C:\Windows Assembly (Win Vista)
2007 won't open older format database