Microsoft Access Password - Securing Your Database

The Microsoft Access password is the simpler part of the Microsoft Access security model.

You have limited protection with the database password to restrict which users have access to the database.

The Access password is stored in an unencrypted form which could compromise the security of the database.

Before creating a password, here are some cautions to be aware of.

Cautions

• Don't forget or lose your password because you won't be able to open your database.

• Don't use a Database password if you are going to replicate the database.

• If you have a user-level security defined for your database, you can't use Database password.

Create the Access Password

{Screen - Microsoft Access Database - Open Database Window}

1. Close the database if it is open.

2. Make a backup copy of the database.

3. On the File menu, click Open.

4. Click the down arrow to the right of the Look In box, select the drive and folder where the database is stored and select the database (.mdb).

5. Click the down arrow to the right of the Open button,and click Open Exclusive.

6. On the Tools menu, select Security and select Set Database Password.

7. Type your password in the Password box.
   • Password guidelines

   • Use names from 1 to 20 characters which may include letters, numbers, spaces and symbols.

   • The characters " [ ] : < > + = ; , . ? *

   • Leading spaces

   • Control characters (ASCII 10 to ASCII 31}

   • Passwords are case sensitive meaning it can distinguish between upper and lower case.

8. Type your password again in the Verify box and select OK.

Notes

• A database password is stored with the database.

• If a database table is linked, the password is stored in the database it is linked to which will allow anyone to see your data.

Remove the Access Password

1. On the File menu, click Open.

2. Click the down arrow to the right of the Look In box, select the drive and folder where the database is stored and select the database (.mdb).

3. In the Password Required dialog box, type the Database password and click OK.

4. On the Tools menu, point to Security and click Unset Database Password.

5. In the Unset Database Password dialog box, type your current password.

So you have set your Microsoft Access Password and can keep prying eyes away from seeing your data.

Just remember to store your Access password in a safe place so you can always access your data.

Subscribe here for FREE!

Every once in a while we're sending out a Windows XP How To ezine. We would be honored if you signed up for it.

We understand you are careful about giving your email address to anyone. But we promise we won't sell or give your email address to anyone, or use it for any other purpose than to send Windows XP How To Ezine.

Important Note: Spam filters that are active at your ISP, mail service and/or mail client, may accidentally filter out any email we send in response. Read how you can make sure you receive messages from us..

Return from Microsoft Access Password to the Home Page

	Enter your search terms Submit search form
	Web www.windows-xp-how-to.com