Upgrade Acess Databases

Hello All,

We have different versions of access databases at our place. We want to upgrade them to 2016.
What are the best practices to do so?
Where to start?

shyam pothiniAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Usually you just import the objects from the older versions to a new Access 2016 accdb and you just work out the issue you may encounter.
Dale FyeOwner, Developing Solutions LLCCommented:
It depends on what versions you have.  Some of the earlier versions, I think mostly prior to A2007 do not have a direct upgrade path to 2016, but everything from 2007-2013 should be able to upgrade relatively seamlessly.

However, there have been some features deprecated over the last couple of versions, so after importing all of the objects from your older databases, perform a compile and resolve the issues that that process highlights.
lcohanDatabase AnalystCommented:
I found this to be not an easy task for sure as these Access database upgrades are  for some reason not very predictable therefor this is what I do whenever I must upgrade one.

1. Mandatory step - place a good known working copy  of the original database on some external storage and temporarily forget about it but make sure is available if needed. This is because often the process may complete with errors and sometimes not all conversion errors get logged as part of the process. This means that potentially you are left "in the dark" not knowing exactly what might have gone wrong with the conversion.
2. There is a convert-database utility for Access 2010, 2013 and 2016. Access 2010 utility will recognize Access 2007 databases however Access 2013 and 2016, it will not. therefor if your version is older than or 2007 you need to start with Access 2010. The Addons can be found here: http://www.addintools.com/documents/access/where-is-convert-database.html
3. Upgrade/convert the database one step at a time until getting to the desired version 2016 however...I would test my app against each version and take a backup of that intermediate DB version if it is all working fine just so you don't have to start over again.

Best of luck to you.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Start with the oldest versions first.
Upgrade to the next minimal level that can be opened by the next higher version of Access.
Test thoroughly.
Repeat until all your databases have been upgraded.
Gustav BrockCIOCommented:
If versions are before Access 2000, run a "Convert Database" from Access 2000 or newer.
Some code may need adjusting.

If versions are Access 2000 and later, create a new database in Access 2016 and import all objects from the old database.
Again, some code may need minor adjusting.

Of course, do create backups as the very first step.

And yes, Access 2016 will read versions all the way back to Access 2000.

old access databases usually fail as they have a reference to some .mda file (forgotten the name).  Don't fret it's rarely ever required, open it, delete the reference and save.
shyam pothiniAuthor Commented:
Thanks all for the replies
Is there any way or any software to convert multiple databases at a time?
Gustav BrockCIOCommented:
Not that I know of. But you could write a looping routine yourself for those databases requiring no code modification.

shyam pothiniAuthor Commented:
Looping routine?
How can I do that?
Gustav BrockCIOCommented:
Oh, many ways. We don't know anything about your environment, so that may be up to you.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shyam pothiniAuthor Commented:
Thanks all
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.