Hi guys!
I have shared my database on a number of networked pc's and set-up
usergroups to control access to certain objects (database has also been
split). However, now that I have distributed the front-end to
colleagues, my security file has been set to apply to all other
databases on their / my computers. Can anybody tell me how I get this
file to apply only to this individual database?
Thanks for your time :-)
Rick Brandt - 31 Jul 2006 13:48 GMT
> Hi guys!
>
[quoted text clipped - 6 lines]
>
> Thanks for your time :-)
The recommended way is to leave users joined to the default workgroup
System.mdw and then provide them with a shortcut that opens secured files
with a command line argument to specify the secured MDW file. The target of
such a shortcut would have this format...
"Path to MSAccess.exe" /wrkgrp "path to secure MDW" "path to MDB"
That is also a good way to test that you applied security correctly. When
joined to the default workgroup they should only be able to open your file
using the special shortcut. If they can open it without using that then you
missed some steps.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Rick B - 31 Jul 2006 13:52 GMT
Sounds like you had them join your workgroup - which will use it everytime
the Access application is started.
Instead, leave them joined to their default workgroup and create a shortcut
for your database. In that shortcut, include the workgroup file to use.
This is all outlined in the various security FAQs that are available. You
should probably look these over. You might also verify that security is
REALLY in place. You might have one of your users join their default
workgroup file and try to open your file. If everything is set up properly,
then they should get an error and not be able to open the file at all.
Here are some good Security links:
Security FAQ
http://support.microsoft.com/?id=207793
The Security Whitepaper is also worth reading to help you understand.
http://support.microsoft.com/?id=148555
Joan Wild:
www.jmwild.com/AccessSecurity.htm
Lynn Trapp
http://www.ltcomputerdesigns.com/Security.htm

Signature
Rick B
> Hi guys!
>
[quoted text clipped - 6 lines]
>
> Thanks for your time :-)
Mikey C - 31 Jul 2006 16:40 GMT
Ah ha!
This worked a treat - cheers guys!
> Sounds like you had them join your workgroup - which will use it everytime
> the Access application is started.
[quoted text clipped - 39 lines]
> >
> > Thanks for your time :-)