.mdw file won't act independent from the original

[Jeremy]

I created a new .mdw file by using the Workgroup
Administrator (I chose a new name and saved it in a
different location). Problem is, whenever I enter new
information (like a new user, group, or password) into
this new .mdw file, the original SYSTEM.mdw file is
updated too. So, the two files are never different. I
want to use a password and user level security on one
Access database, but I want all my other Access databases
to be password free...thus the second .mdw file. How do I
get these two files to act independently?

Jeremy

 

[Immanuel Sibero]

Hi Jeremy,

You might be joined to the new mdw file. Use the Workgroup Administrator to
rejoin your System.MDW. When you need to use the secured application, use a
shortcut. The target of the shortcut should be:

"<path to msaccess.exe>" "<path to frontend.mdb>" /wrkgrp "<path to
security.mdw>"


HTH,
Immanuel Sibero

 

[Jeremy]

Thanks for the response Immanuel.

I have used the Workgroup Administrator to join the
system.mdw file and I have set up the shortcut. Still,
however, when I enter users/groups/passwords into the
new .mdw file, they are also entered into the system.mdw
file. Any other ideas on how to "separate" these files so
they act independently?

Thanks,

Jeremy

-----Original Message-----

Hi Jeremy,

You might be joined to the new mdw file. Use the Workgroup Administrator to
rejoin your System.MDW. When you need to use the secured application, use a
shortcut. The target of the shortcut should be:

"<path to msaccess.exe>" "<path to

frontend.mdb>" /wrkgrp "<path to

 

[Joan Wild]

Can you please describe how you 'know' that the users are being added to
system.mdw? How have you deduced that?

 

[Immanuel Sibero]

Hi Jeremy

Sorry for the late reply. Your answer to Joan's question would certainly
help. An Access session is always joined to one .mdw file only. So an Access
session will not normally update more than one .mdw files.

Immanuel Sibero

 

[TC]

There is >no way< that defining a user in one particular workgroup file,
will automagically add that user to any other workgroup file(s). Just won't
happen - period!

HTH,
TC

 

[Immanuel Sibero]

automagically

I like that word!!

Immanuel Sibero

 

[TC]

Isn't it good! I sometimes say to myself, "why the ^&^%$##@ will this not
work automagically?"

TC