Tuesday, April 05, 2011

Backward Compatibility from Access 2010 to Access 2007

If you are creating an Access database using 2010 but your audience requires a solution that works in Access 2007, the best way to do this is to use Access 2007. Of course you will be like me this week and create the database using 2010 and add features that are not 2007 compatible. If you do that you will get a warning "Unrecognised database format".  That will excite you. So what have you possibly done wrong and what is the solution

You have added the Navigation Control
You have added a Data Macro
You have added a Calculated Column in a table
You have added a Web Browser control

This compatibility topic is discussed at Microsoft here

1 comment:

Garry Robinson said...

Here is a page that tries to explain this issue http://blogs.office.com/b/microsoft-access/archive/2010/01/13/backward-compatibility-between-access-2010-and-access-2007.aspx

One thing to help you along is to make sure you are running Access 2007 SP2.