User-level security

[tadams]

I created User level security on a database that needed to
be secured... Now whenever I go to create a new database
(that does not need a password) I am asked for my username
and password. I am also prompted for it whenever I try to
access this new database. How do I get rid of this and/or
stop this?

 

[Bruce Loving]

Access is all or nothing when it comes to security.

a work-around is to create a Desktop Shortcut to open the database
using the -wrk command line parameter, check the Books online

 

[Joan Wild]

When you applied security on the one database, the first step was to create
a new workgroup file. Unfortunately, Access assumes you want to use this
new mdw as the default for all Access sessions. You can use workgroup
administrator to rejoin the default system.mdw. Create a desktop shortcut
to access your secure mdb.

The default mdw will be used for all sessions. You use your shortcut to
open the secure mdb. The target would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"