Changing back to original System.mdw Workgroup file

[Jean]

Hello,

I have just read through the MS Access Security FAQ, and had a go at
securing my database, but now I am stuck.

I successfully set up a new .mdw file, say DEPARTMENT.MDW. With this
file, I set up users and groups, and then the permissions to objects in
my db. Now, I would like to reverse the situation I am in now, i.e. no
matter what db I open from my PC, it doesn't ask me for a username and
password.

I assume that I must used the Workgroup admin and join the original
SYSTEM.MDW file, but when I do this, I still get prompted for username
and password when opening a db, with the usernames I set up for
DEPARTMENT.MDW.

How do I get back to the state where I am asked no passwords for any
db? Please help!

Regards,
J

[Scott McDaniel]

The Security FAQ topic #34 addresses this issue.

http://support.microsoft.com/Default...#_Toc493299703
"Jean" <je**********@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hello,

I have just read through the MS Access Security FAQ, and had a go at
securing my database, but now I am stuck.

I successfully set up a new .mdw file, say DEPARTMENT.MDW. With this
file, I set up users and groups, and then the permissions to objects in
my db. Now, I would like to reverse the situation I am in now, i.e. no
matter what db I open from my PC, it doesn't ask me for a username and
password.

I assume that I must used the Workgroup admin and join the original
SYSTEM.MDW file, but when I do this, I still get prompted for username
and password when opening a db, with the usernames I set up for
DEPARTMENT.MDW.

How do I get back to the state where I am asked no passwords for any
db? Please help!

Regards,
J

[Jean]

Thanks Scott,

I replied through DevelopersDex to this message already.

Regards,

Jean