How can I help protect some parts of my application (an add-in), yet make others totally open to any Microsoft Access user?
You will need two workgroup information files: one that you will use to help develop and protect your application, and one that you use to distribute it. The distribution workgroup file can be the default that is installed with Microsoft Access, if you prefer. When you help protect your application using your workgroup file, you will want to make sure that the default Users group has only the permissions that you want all users to have, while full permissions are held only by a member of your own System.mda/mdw. Granting the Users group permissions on “public” objects means that the Users group in other workgroup files (including the default System.mda/mdw) will inherit them. You will need to log on to your development workgroup file in order to modify your entire application. • Follow the steps outlined in Section 1, “What are the steps to help protect a database?” for securing your application. • Use Security/Permissions to assign or revoke permissions from the Users group that you d
