As Joan wrote (so I'm now an "expert" :-) ) start the program Msaccess and
join the system mdw.  Then set up your shortcut to the secure database as
follows (this is from my installation, replace the paths with yours)

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Program
Files\Fionns Programs\FionnsFinac.mdb" /wrkgrp"M:\mks.mdw"

The users log on through the defined workgroup file and hence can access
your database. The logon only exists for the time they are using this db, all
other times they are still connected to the system (unsecured) workgroup (and
wont be able to open the secured db if they try to get into it that way).  It
a v neat trick and is documented in the help file but I hadn't come accross
it until Joan pointed it out.

Hope that helps

Finnie

Access ships with security turned 'on'.  By default you are joined to a
workgroup file called system.mdw.  Every time you open Access it silently
logs you in as a user called 'Admin'.

So when you 'join' your secure mdw on the server, it is now the default mdw
used for all sessions.  It is the mdw that determines whether you are
silently logged in as Admin (for unsecure mdbs), or you have to provide a
username/password.

The idea is to leave each computer joined by default to the standard
system.mdw that ships with Access, thus requiring no login.  For the secure
mdb, you want to over-ride the default and use the secure mdw.  It would be
tedious to have to use the workgroup administrator every time you wanted to
switch workgroup files.  So instead use a desktop shortcut - its target
would look like...
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

If everyone has installed the same version of Access, and installed to the
same location, you can create the shortcut and then just copy it (it's just
a lnk file) to each user.