Join David Rivers for an in-depth discussion in this video Converting older databases to Access 2007, part of Migrating from Access 2003 to Access 2007.
If you share a database with someone who has yet to upgrade to Access 2007, you need to continue working on the older format. However, if everyone has upgraded to Access 2007, or if you need the added functionality now found in Access 2007, you can take an older database and convert it to the new format. That's what we're going to do with this one called CustomerAddressList2003. On the title bar, you can see it's an Access 2002 - 2003 file format. When we go over to the Navigation pane, you might be seeing tables, forms or all objects.
Click the dropdown and select All Access Objects. You can see there's actually a table, a query, form, even a report in here, all of which will be converted to the new format. And to do that, it's really quite simple. We click the Office button and select Convert. Now we need to choose a location where we're going to create this new version of our database. So, for example, you might want to put it in your documents or right on the desktop. The name you can see is going to be the exact same name but with the new extension.
So, if you want, you can change the name as well. I'm going to change it to 2007, and the Save as type, by default, now shows up as a Microsoft Office Access 2007 database. All you need to do is click Save. Now you'll see this message that the database has been upgraded to the new format. The new database cannot be shared with users of Access 2003 or earlier versions. Just a reminder, click OK to close up that message, and you're now working on your Access database using the new formats, and you'll have all of the functionality available to you here in Access 2007.
- Comparing the Access 2003 and 2007 interfaces
- Changing the default file format
- Ensuring compatibility with the Compatibility Checker
- Controlling Access with keyboard shortcuts
- Adding attachments to records with the Attachment field type
- Converting older databases
- Filtering data without a query
- Designing in the improved Layout View