Security access to one database only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Scott - 28 Jul 2005 13:04 GMT

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.

Reply to this Message

Rick Brandt - 28 Jul 2005 13:47 GMT

> 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
[quoted text clipped - 6 lines]
>
> Thanks in advance.

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"

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message