How To Convert an Access 2003 Database to Access 2007 format

  • Share
  • Share

How To Convert an Access 2003 Database to Access 2007 format

convert access 2003 mdb database 2007 formatAccess 2007 introduced new elements to the Microsoft Office database component. The most notable change is the file extension. Access 2007 databases are saved with an accdb database extension. This differs from the past versions that were saved as a mdb extension. The new extension logically makes more sense since it is the abbreviation of the access database software. It’s also confusing because the old mdb extension has been used for decades and there is a certain comfort level with using it.

Convert Access 2003 to 2007 Format

Converting the 2003 database to the new 2007 format can be done by using the new Convert option that appears in Access 2007.

Open the 2003 database in Access 2007 by clicking the Office button and selecting Open. Browse the files and locate the 2003 file. Click the file and the Open button. The database opens.

Click the Office button on the ribbon. Select Convert. You are prompted to save the file. Type a new name in the File Name file. Click Save.

Look in the lower right section of the database window to see the progress of the conversion. You may see converting and compacting messages. When the conversion is done, you will get a prompt window from Access. Click “Ok” to confirm the Access 2003 conversion.convert access 2003 conversion

Related Posts Plugin for WordPress, Blogger...

Related posts:

Microsoft Access Tutorial: Create a Database From a Template Using Access
Getting started with Microsoft Access: Create a blank database
10 Ways to Use Queries In Microsoft Access

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *