mdw applied to all my access db???

[brickelldb]

[Access 2003 in Windows XP]

For the first ever, i created a security group (mdw) for 1 db that i have.

Tools>Security>Workgroup Administrator

I proceeded to "Create" and created a mdw called ProntoSec.mdw for a database called prontoparts.mdb and saved it in the same folder where prontoparts.mdb is stored.

I set the admin password....and that was that....

****Now, when I open ANY access database, it prompts me for a user/pass. And the admin and password I set in the prontosec.mdw for prontoparts.mdb database works for all databases****

What did I F*** up??? I searched my computer and found the System.mdw (which i believe is the default access system mdw file) but am now worried that this mdw will apply ALL OVER.

PLEASE HELP AAAAHHHHHH

 

[KenHigg]

I suggest you re-join the system.mdw and use the command line parameter to tell your secure db to use the new .mdw. Hope that makes sense.

 

[brickelldb]

Yesssssir. Thanks - got it back to normal.....

I will have to lookup how to make the mdw apply to only the specific database I guess - Is that what you mean by "use the command line parameter to tell your secure db to use the new .mdw"?

 

[KenHigg]

Yes. Here's a read on it:

Link