Workgroup Issue...

[KarloZ]

hello everyone,
i created a workgroup file for my access program using the workgroup asministrator. i created permissions for each user groups. so, everyone now needs to log before they can use the program. but when i tried to create another workgroup file and join on that workgroup, what happens is everything i designed for protection is lost. I mean, the security settings was reset. now, everyone can now have access to the data. what can i do to resolve this problem? any other security for access that i can use? thanks in advance.

karloz

 

[JJayUK]

Workgroup files are annoying.

Try creating a workgroup file and then a shortcut to the database specifying that file. EG

C:\Program Files\Microsoft Office\Office\MSACCESS.EXE "PATH TO DATABASE" /wrkgrp "PATH TO WORKGROUP FILE"

In the shortcut.

Whenever users click on that shortcut they will only use the database with that file....BUT...Access defaults to "Admin" if no work group file is specified.

The answer to this is to enter the Database and revoke ALL permissions for the Admin account and set up a new Admin account with a different name. That way if someone happens to click on the database without using the shortcut they will be told they do not have permission to access it.

Regards,
JJayUK

 

[KarloZ]

Some employees knows about programming, if they can create a workgroup file and replaces the old secured workgroup file, everything is lost!. they can now access the database with an admin permissions...

karloz