Join David Rivers for an in-depth discussion in this video Converting older databases to Access 2010, part of Migrating from Access 2003 to Access 2010.
If you're sharing or collaborating on database files with users who have not upgraded to Access 2010 - they're still using Access 2003 - you'll want to continue to work in the older format; however, once everyone has been upgraded, or if you need to make use of some of the functionality available in Access 2010, then you might consider converting the older database format to the newer format, and that's what we're going to talk about right now. Here in Access 2003, you can see, we've got our Customers2003 database open. It's an Access 2002 to 2003 file format.
We have one table, called Customer_Address_List. We don't have any queries. We do have a form and a report. Just want you to see those, because when we close this up and switch over to Access 2010 and open that same database file by going to Backstage View, clicking Open and then the navigating to the 02_01 subfolder of our Exercise Files, you'll notice that we've got our Customer_Address_List Table, our form and our report showing up here in the Navigation Pane. If you're not seeing everything, you may need to click this little dropdown button to choose what you're are viewing.
In this case, you can see I've got All Access Object selected. Now, when we do the conversion, all of these objects will be converted to the newer format, and unlike Access 2007 where there was an actual Convert feature, all we do here is save this in the new format. We do that by going to Backstage View and then selecting Save & Publish, down near the bottom of our Navigation Pane. You'll notice, by default, under File Types, Save Database As is selected, and over on the right-hand side, you'll see the various formats, including our default format - you haven't changed it - which is an Access Database using the new format .accdb extension.
So with that selected, all we have to do now is click Save As, and if you want, you can give it a new name or keep the same name, but notice the extension will change. And you can choose your location. I'm just going to change my location to the Desktop, where it's easily accessible, and click Save. And you'll see this little message pop up that the Database has been upgraded to the new format. Notice the new format is still Access 2007, even though we're here in Access 2010. And it cannot be shared now with users of Access 2003 or earlier, so just a little reminder of what's happening.
When you click OK, you're now working in the new format. You're going to see the security warning, and you can unable the content by clicking the button, and now you've have access to the table, the form and the report. Let's just open up the form, for example, with a double-click. That's what it looks like using our new format here in Access 2010.
- Comparing the Access 2003 and 2010 interfaces
- Exploring the Ribbon and Backstage view
- Dealing with file compatibility issues
- Converting older databases to the 2010 format
- Creating navigation forms
- Adding field-level attachments
- Formatting rich text in memo fields
- Using keyboard shortcuts