User level security problem

[Jim]

i work for the Police. I am designing a members database
which will need to be restricted. Restricted on such
levels as viewing, and editing. I set up the workgroup
and everything worked fine. That is until I shutdown
Access, and opened another access database that we use to
record briefs of evidence. It started asking me for a
password to access that, and subsequently every time
Access is opened this password prompt comes up, and I
don't want that. How can I set security to be exclusively
for that one members database?

Any help would be much appreciated,

Cheers

 

[Rick Brandt]

i work for the Police. I am designing a members database
which will need to be restricted. Restricted on such
levels as viewing, and editing. I set up the workgroup
and everything worked fine. That is until I shutdown
Access, and opened another access database that we use to
record briefs of evidence. It started asking me for a
password to access that, and subsequently every time
Access is opened this password prompt comes up, and I
don't want that. How can I set security to be exclusively
for that one members database?

Any help would be much appreciated,

Whether you are asked for a security login or not is determined by the
workgroup file being used, not the database file being opened.

When you secured your other file you created a new workgroup file (one that
requires a login) and that process also made that workgroup your default.
You need to use the Workgroup Administrator tool to change your default
back to "System.MDW" which is what it was before you secured the other
file. Then you create a shortcut for opening the secure file that
specifies a non-default workgroup as a command line argument. That way you
only get prompted when you open that file using the special shortcut.

In newer versions of Access you can get to the Workgroup Admin tool from
inside Access itself. It's on the security menu. On older versions you
have to run WRKGADM.EXE. This will show you what your current default
workgroup file is and allow you to change it.

BTW, after you change your default back to System.MDW and you can open
Access without a login prompt, you should then try to open your secure
file. You should NOT be able to. Chances are though that you will because
the wizard does not properly secure files (go figure). Most often it is
because the file you "thought" was secure still has the user "Admin" listed
as the owner of the database. You will need to change that. Owners have
permissions beyond those that are explicitly given to them in the security
settings.