Access 2000 security

[HOB]

Hi, I am new. Therefore please appologize if forum rules are not all known by me.

Problem:
To protect an Access DB that is frequently used by about 100 users on a company network we have installed Access security (Access 2000). We created a corresponding workgroup with user and group accounts. All works quite well when users have joined the corresponding workgroup. As there exists more than one workgroup, users are allowed to switch between different workgroups. That means they can always switch back to their default "system.mdw" workgroup definition file. Doing this or having never joined the workgroup bearing the policies for the secured database they regain immediately admin status. This means full control over the database and all its objects. So there is no security at all. Not allowing users to open the database if they have not joined the workgroup would probably solve the problem. Any suggestions how to force users to join a wg before opening the database?

Thanks for your assistance in advance!

HOBforce

 

[ghudson]

You should never have a users PC "joined" to a secured workgroup. You should use custom shortcuts that open the db using your workgroup file. Is your secured workgroup file still named "System.mdw"? If so, then that in only one of your problems.

Here is a sample shortcut "Target:" to open a secured db: [all on one line]
"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "C:\Test\YourWorkgroupFile\Secured.mdw" "C:\Test\YourDatabase.mdb" /user TestUser

Search this site for these keywords [not at the same time!]:

System.mdw
security
work groups

And you will find a ton of threads where your questions have already been asked and answered.

HTH

 

[Pat Hartman]

If your users acquire admin status if they open your db while joined to system.mdw, then you have not properly secured the db. Read the security FAQ again very carefully. You will see this listed as a problem with a solution.

Once you get past that problem ghudson is correct, you should NEVER be joining workgroups. You should ALWAYS use shortcuts with the /wkgrp parameter to open your secured databases. Specifically joining a workgroup, updates the registry and changes your default workgroup. This generally causes lots of confusion. You'll see lots of posts on this topic also.

 

[Oldsoftboss]

Something I came across some time ago. May have some usefull info for you.

Dave