Question how to open a 2010-file in 2007 MSoffice

[ariansman]

I have made a DB in access 2010. I want it to be opened in a machine which runs access 2007. But it says: Unrecognized database format.
i read an article here: http://msdn.microsoft.com/en-us/office/cc907897.aspx that attributes this problem to new features on 2010 that are not available in 2007.I cant imagine my DB without calculation or expressions in query columns. more over it will take a lot of time to remove them all one by one and substitute them with something that still fits my needs.
Anyone knows an easier solution?
i think i should upgrade the target machine.

 

[Mr. B]

Calculations in query columns is not the thing that is causing your issue. You have evidently used some new feature that is only available in Access 2010.

If the user that is using the 2007 version of Access does not need to make any changes to the application then you could download and use the Access 2010 runtime version on that machine and your 2010 database would work there.

 

[Pat Hartman]

The problem is that if you even tried an A2010 feature, it makes the db not usable in A2007. The solution is to create a new empty database and import all the objects. If you still have a problem, they you actually used an A2010 feature and should go with Mr. B's suggestion to distribute the A2010 runtime.

Calculations is queries are fine. Calculated table columns are not. My position regarding the "features" added to ACE tables in A2007 and A2010 is - if they are not compatable with SQL Server - I don't use them period! All the "features" added in these two versions are easily replicated using standard design techniques so using the propritary versions just make the application not upsizable.