How to develop an application with ms-access-2016 and make it compatible with previous versions (2007)

Victoire Nkolo 1 Reputation point

Hello everyone

Am using MS Access 2016 to develop an application managing images. But some of my users are still using MS Access 2007 on their computers. And the receive the error "unrecognized database format".

So I would like to know if there is any solution for this. Like making my application compatible for previous versions.

I did some researches for days but not satisfied yet.

Need any help, solution or advice please. Thanks

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
798 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. DBG 2,306 Reputation points

    The safest way is to try and use Access 2007 to develop and modify your database until every users upgrades to 2016. Otherwise, you could try to avoid using any "new" features to try to keep the database compatible with 2007.

    You could try the following steps:

    1. Get a working copy of the 2007 database
    2. Keep a backup copy of it
    3. Try to modify the Access 2007 database using 2016 by only adding one feature at a time
    4. Test the new database in 2007
    5. If it's not broken, try adding the next feature you need using 2016
    6. Test it again
    7. Keep doing this until you figure out which feature of 2016 is not compatible with 2007 and then figure out another way of doing it

    Hope that helps...

    0 comments No comments