Compatibility between Access 2007 and Access 2010

0
votes

Is it possible for Access 2007 to open Access 2010 databases? My problem is at work we use Access 2007 but I need to edit the database at home where I use Access 2010. After I edit and save in Access 2010 and I open the database with Access 2007, I get the error "Unrecognized Database Format"... Please advise.

Thanks!

1
ms-access
Not unless you save the DB as Access 2007 format when you change it. It's impossible for Access 2007 to be aware of Access 2010 DBs, since 2010 didn't exist when Access 2007 was created and released. (It's the same reason the parts from your new Ford Explorer don't fit on your father's 2009 Ford Explorer, so you can't just swap out the on-board computers and expect her car to work.) – Ken White

1 Answers

0
votes

As far as I know in theory 2007 and 2010 should use the same format. But in real life they are different! One problem might be the references in VBA (VBA Windows, Tools, References). If you take a database from a computer with Access 2007 and work on the database in Access 2010 then some of these references are automatically updated to the newer office version (i.e. Microsoft Office 14.0 Access database engine Object Library). And when you try to use this database in Access 2007 again it won’t work because the references are changed. You can easily fix this by changing the reference back to what it was in 2007. I.e. change “Microsoft Office 14.0 Access …” back to “Microsoft Office 13.0 Access …” on the PC with Access 2007. Then at least that problem is solved. This is one of the problems between 2007 and 2010 but there are others which IMHO sometimes matter and sometimes don’t create a problem.