Help protect your database completely by following the steps discussed in Section 1, “What are the steps to help protect a database?
• Make sure that all permissions to modules are revoked for the Users group and the Admin user. (If you have used the Security Wizard, this is already taken care of.) • Grant full permissions to the Admin user and the Users group for all the objects that you want everyone to be able to use. • Distribute your application using the default workgroup information file. Because there is no password assigned to the Admin user in the default System.mda/mdw, everyone logs on as Admin and everyone has only those permissions you have assigned the Admin user and the Users group. When you need to make modifications to your application, you need to switch to your development workgroup database and log on as the owner of the database. Beginning with Microsoft Access 97, a database can be converted to an .mde file. This removes all editable code from the database and makes the design of forms, reports, and modules inaccessible to users. It has no effect whatsoever on data or on linked tables. The acc