Workgroup file

[Guest]

I have a secured database (user-level secured) on a shared network. The
problem I have is periodically the users (full data users) have to log back
into the workgroup. For some reason they are being logged back into the
default mdw. What can cause this or is there another way I can secure my
database without having everyone have to log into a secured mdw? Thank you
for your help.
Eugene

 

[Rick Brandt]

I have a secured database (user-level secured) on a shared network.
The problem I have is periodically the users (full data users) have
to log back into the workgroup. For some reason they are being
logged back into the default mdw. What can cause this or is there
another way I can secure my database without having everyone have to
log into a secured mdw? Thank you for your help.
Eugene

I have no idea what would be changing their group membership but generally
it is not recommended to change the user's default workgroup from System.mdw
anyway. What is better is to give them a shortcut for your secured app
that specifies the correct mdw file as a command line argument. The target
would look like...

"Full path to MSAcces.exe" /wrkgrp "Full path to MDW" "Full path to MDB"

 

[Guest]

Thanks, I have tried the command line but it does not work. My command line
looks like this:

"I:\Pilot Plant\Forms\TPDC Forms Database.mdb" /wrkgrp "I:\Pilot
Plant\Forms\Secured.mdw" "I:\Pilot Plant\Forms\TPDC Forms Database.mdb"

My shortcut target for MSAccess.exe is grayed out with: Microsoft Office
2000 SR-1 Professional

Is there a different target I should us, because I cannot find it on the
computer anywhere. Thanks for your help.

 

[Guest]

I figured out the path to the exe file for the msaccess. It was buried in
the srccode. Thanks for all your help. The shortcut is now working.