- database solutions and downloads for microsoft access

Microsoft Access Database Security

Changing a Password:

Now that you've created new Microsoft Access User Accounts, it's time to look at Security Account Passwords.

Passwords that are entered when you log on to Access are known as Security Account Passwords. The primary purpose of these passwords is to ensure that no other user can log on using your name. If this is the first time you are adding a password to your Access account, you do not have to use the Old Password text box.

The Admin user has full permissions to all database objects. The Admin user’s password is empty, so anyone can log on to Access as the Admin user. To make your system more secure, you can remove the Admin user from the Admins group. In this tutorial, you'll do just that.

Task A-5: Setting your logon password and removing the Admin user from the Admins group

Objective: To add a password for yourself and to delete the Admin user. This information relates to the sample Microsoft Access database download

  1. Exit Access.
  2. Start Access. Don't open a database.
  3. Choose Tools, Security, User And Group Accounts. The Logon dialog box opens.
  4. Log on by using your name (as you typed it in when you created your own user account) and no password. There's no password assigned to your name yet. After you click OK, the User And Group Accounts dialog box opens.
  5. Select the Change Logon Password tab.
  6. In the New Password and Verify text boxes, type password. Remember, the password is case-sensitive.

    Changing the logon password for your username
  7. Click Apply to accept the change and leave the dialog box open.
  8. On the Users page, select the User Name Admin.

    Selecting the Admin User
  9. From the Member Of list, select Admins.

    Showing the Member of List
  10. Click Remove to remove the Admin user from the Admins group. The Admin user remains a member of the Users group only.

    Showing the Admin remains a member of the Users group only.
  11. Click OK to accept the change and close the User And Group Accounts dialog box.

Next we'll take a look at The Security Wizard.

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.