databasedev.co.uk - database solutions and downloads for microsoft access

Microsoft Access Database Security - Previewing Security Permissions:

Previewing Permissions

If you want to view the permissions for a particular object, you can create a report that includes the object’s design information and permissions listed by user and group. Use the Database Documenter to view the definition for one object or multiple objects.

Let's use the Documenter to preview a report for user and group permissions as they're set for the Customer form.

You will have created these user and group accounts and permissions in the previous tutorials listed at the bottom of this page using the sample database - MyNewApp.mdb..

Task A-10: Previewing reports about user and group permissions by object.

  1. Choose Tools, Analyze, Documenter to open the Documenter dialog box.
  2. Display the form objects. Check frmCustomer to run the report on just this one form.

    The Documenter, displaying the form objects
  3. Click Options to open the Print Form Definition dialog box.
  4. In the Include For Form section, uncheck Properties and Code. Check Permissions By Users And Groups. To make your report run faster, check only those options you need. Printing properties can fill up lots of pages.

    Setting the print options for including in the form.
  5. In the Include For Sections And Controls section, select Nothing. Again, this is to keep the report shorter and include only the information you need.

    Setting the print options for including in the section.
  6. Click OK to close the Print Form Definition dialog box.
  7. Click OK to run the Documenter. This might take several minutes to run, so be patient. The more information that you request from the Documenter, the longer it takes to run the report.
  8. In the Object Definition report for the Customer form, look at the user and group permissions.
  9. Close the report.

Now we've investigated User and Group Security in Microsoft Access, let's take a look at Securing a Database with a Database Password

Go to page:

  1. Steps to Securing an Access Database by Using User-level Security
  2. Setting Logon Procedures
  3. Group Accounts
  4. User Accounts
  5. Changing a Password
  6. The Security Wizard
  7. Permissions
  8. Testing Security
  9. Documenting Database Security
  10. Previewing Permissions
  11. Securing a Database with a Database Password
  12. Distributing the Secured Application

Recommended Reading:

If you are serious about your Microsoft Access security, then you should check out Garry Robinson's book Real World Microsoft Access Database Protection and Security

About the book:

Real World Microsoft Access Database Protection and Security

Microsoft Access is the most popular desktop database in the world today and its very popularity means that its security measures can be easily compromised. Real World Microsoft Access Database Protection and Security takes a different approach than all the other Access books in the market by focusing from the start on all the issues that will help protect your database. It approaches protection and security from a task-by-task perspective and provides details that when put together will make your database more secure.

This book will help you to keep your staff from looking at your salary tables, stop your customers from looking at the design of your software that you distribute, and help you decide which security options are worth doing and which are generally a waste of your time.

Garry writes from a very experienced developer's point of view and he discusses in detail how to program all types of security issues including hiding tables as system tables, producing databases that password cracker software cannot easily crack, backing-up databases, menus, queries, and even user surveillance.