Access database migration

rickvandelaar used Ask the Experts™
We're dealing with a upgrade from Office 2007 to 2016. After checking how much Access db's are in use, we found out that users made some in Access 97 and up.

What is the best approach to check compatibility with Access 2016?
Are there must have tools, or does anybody have experience with this?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

If they're working in 2007, then chances are they'll work fin in 2016, but the only way to tell is to actually test them in 2016. I'd advise you to make a copy of the database, and test that copy.

The exception would be any databases still in the A97 format. You'd need to convert them to (at least) A2003. To do that, you'll need a copy of Access 2003.

I don't know of any tools that would do this for you.
ste5anSenior Developer

Just import all objects and IMEX etc into a new database. Set references when necessary. Make it compile. Review the data model. Let the users test.

As they worked under 2007, I don't expect hard to solve problems. The question is: How much work are you willing to invest? Cause this is a good chance for cleaning up things and especially documenting them :)
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

The other issue to be aware of is if you installed A2016 in 64 or 32 bit.  Hopefully 32 bit as then as Scott said, should work without too much difficulty.

A2010 did tighten up on a lot of syntax checking, so make sure if your writing VBA code that it compiles.

If you installed 64 bit edition of Office though and you've made any windows API calls, you'll need to do some conversion work or uninstall and install the 32 bit edition (better choice).

Distinguished Expert 2017

A97 format is a problem since it is no longer supported.  You would need to convert the older databases to a newer format using A2007 so you might as well go to the .accdb format.
There were many features deprecated in Access 2013, so if you were using things like pivot tables, pivot charts, graphs, ADPs, etc., they won't work in 2016. Stick to Access 2010 if you need them.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial