Workgroup security

[Alec]

I have 2 problems with Access 2002 and the whole workgroup
concept.
First of all, if I want to assign different workgroups to
different databases, the command-line /wrkgrp does not
work when added in the command line of a shortcut. It's
like access was always opening the current workgroup
regardless of the command.
My second problem is the security of my databases. How can
I prevent somebody, who is just a user with limited
permissions, from changing workgroup or create his own to
have a full access to the database? So far, I haven't
found the way. If it does not exist, tell me how to secure
my database otherwise.
Thank you for your help. I have drained all my ressources
for this matter.

 

[Bonnie]

Your shortcut needs to have:

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "s:\rps\XPConfirm.mdb" /wrkgrp
s:\rps\security\tables\rps.mdw

First segment is your application, second is your DB and
the third is your workgroup file. (Keep the quotes
punctuation.)

Hope that helps explain it.