MS Access 2010 compatibility with Access 2007 issue

Posted on 2012-09-14
Last Modified: 2012-09-29

I have an access database that is being developed in Access 2010.  For some reason I have done something that has stopped it from being backwardly compatible with Access 2007.  As we have a mixed environment of Access 2007 and Access 2010 I can no longer release the new version of my database.

Is there an easy way to work out what function is being used that has stopped it from being backwardly compatible or if there is a way to fix it.

Thanks in advance
Question by:teknite
    LVL 65

    Expert Comment

    by:Jim Horn
    >I have done something that has stopped it from being backwardly compatible with Access 2007
    Defining 'something', or at least spelling out the error(s) you are experiencing when running the app in 2007, would be an excellent first step.
    LVL 9

    Expert Comment

    There is a specific list of things that will cause incompatibility, are you using any of them?
    LVL 77

    Accepted Solution

    You are probably wasting your time trying to make a 2010 app compatible with 2007.
    MS's list of issues to address is probably less than half the story. But of course you could be lucky and hit the one thing that makes it work in your case.
    You'll find thousands of posts on google addressing the same subject and each of them will involve a different 'solution'.
    My contribution to any attempt you make is.... get rid of all layouts in forms.

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now