Removing User-Level Security

The only way to remove user-level security while working with Microsoft Office Access 2007 is to convert the .MDB file to an .ACCDB file. The database that you are converting cannot be encrypted, and you must belong to the Admins group of the workgroup used to secure the database.

To convert a database to the .ACCDB file format, take the following steps:

1. Click the Microsoft Office button and select Convert. The Save As dialog box appears.
2. From the Save In list, select a location for the database.
3. Make sure that you set the Save As type to Microsoft Office Access 2007 Database (.ACCDB).

An alternative is to use the Save As command to save an Access database in the .ACCDB format. Here are the steps involved:

1. Click the Microsoft Office button and select Save As, Access 2007 File Format. The Save As dialog box appears.
2. From the Save In list, select a location for the database.
3. Make sure that you set the Save As type to Microsoft Office Access 2007 Database (.ACCDB).
4. Click Save to complete the process.