How Can I Lock the Database Table Structure in MS Access 2007?

Microsoft Access 2007 is a database application that is included the Microsoft Office suite. It allows users to create tables to store data in a tabular format containing rows and columns, then edit and search those databases using reports, forms and queries. It is also allows for multiple users to work on a database at the same time to increase productivity. If you need to lock the database table structure from editing, it is possible to do so with a few simple steps.

Instructions

1. Click the "Start" or Windows button in the lower left corner of the screen, then scroll to "Microsoft Office."

2. Click "Microsoft Access 2007" to launch the program.

3. Select the "Office" button in the upper left corner of the screen, then choose the "Open" option.

4. Navigate to your Access database then click the arrow next to "Open" at the bottom of the window and select the "Open Exclusive" option.

5. Select the "Database Tools" tab at the top of the screen.

6. Click the "Encrypt with Password" button in the "Database Tools" section at the top of the screen.

7. Type your password into the "Password" field, then retype it in the "Verify" field and click the "OK" button.

Tips & Warnings

• To remove the password from a database, click the "Database Tools" tab at the top of the screen, then click the "Decrypt Password" button and type the password.

References

• Microsoft: Encrypt Database by Using a Database Password