Security access to one database only

S

Steve Scott

I have been through a length tutorial to get me up and running with user
level security. But all it seems to have achieved is the allowing of
different users to start up access on my PC. What I actually want is to
secure one specific database only with user level security ie when they open
the database file it prompts them for a User name and passord. For all other
databases I don't want this to happen. Is this possible? I also want a log
file updated that logs the time the User opens and closes the database - is
this possible??

Thanks in advance.
 
R

Rick Brandt

Steve said:
I have been through a length tutorial to get me up and running with
user level security. But all it seems to have achieved is the
allowing of different users to start up access on my PC. What I
actually want is to secure one specific database only with user level
security ie when they open the database file it prompts them for a
User name and passord. For all other databases I don't want this to
happen. Is this possible? I also want a log file updated that logs
the time the User opens and closes the database - is this possible??

Thanks in advance.
Click to expand...

Access security "behavior" (having to log in or not) is controlled by the
workgroup file that Access is using, not the MDB file you are opening. If
you make your default workgroup one where the user "Admin" has a password
then you have to log in. If you make your default workgroup one where
"Admin" does not have a password then you are not asked to log in.

What most do is leave their default workgroup setting alone and set up
special shortcuts for secured files that specify a non-default workgroup for
that session only. The shortcut's construction is roughly...

"path to MSAcces.exe" /wrkgrp "path to workgroup file" "path to MDB file"
 
Top