How to Convert Access 2003 Database to Access 2007
Converting a Microsoft Office Access 2003 database to the new Access 2007 format is done by opening the database in Access 2007. Once the database is opened, it can be converted to the new Access format. The old format used the extension of MDB while the new Access format is ACCDB. The convert option appears on the Office menu when the Access 2003 database is opened. After the conversion is done, your old database will have the new Access 2007 ACCDB extension.
Other People Are Reading
Instructions
-
-
1
Open Access 2007 and select the Access 2003 database. Click the "Office" button and click "Open." Browse your files and locate the Access 2003 database. Double click it when you find it and the database will open.
-
2
Click the "Office" button and click "Convert" and the "Save As" windows will open. Click "Save." Access will start converting the older database to the new format. If you look at the lower right message bar of your Access window, you will see the database converting and compacting messages.
-
-
3
Confirm the conversion by clicking "OK" at the upgrade prompt. If you had macros in your previous database, you may need to enable them. This is done by clicking the warning message across the top of your database window and clicking the "Enable" button. This will also complete your database conversion from Access 2003 to Access 2007.
-
1
