Database security

[kstuart]

I have just finished setting up security on my database. There are two issues I am not crazy about.

The first is that any users in the network who are not part of the Access workgroup that I set up can get into the database (Which resides on a server for now) and have all rights.

I removed user Admin from the Admins group and removed all rights for the Users group. Any way around this?

The second issue is that the security I have set up for this database now impacts every existing and new database on my desktop.

Any ideas.

 

[Opengrave]

The second issue is that the security I have set up for this database now impacts every existing and new database on my desktop.

In my limited experience it is better to not use the workgroup administrator to attach a workgroup file to an Access database rather it is better to call it from a batch file. This seems to help prevent 'attaching' every access database to the workgroup file as you mentioned. Use access help and search on the /wrkgrp switch for instructions on how to start Access with a specific workgroup security file using a one line DOS batch file.