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?

Regards
shyam pothiniAsked:
Who is Participating?
 
Gustav BrockCIOCommented:
Oh, many ways. We don't know anything about your environment, so that may be up to you.

/gustav
0
 
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.
0
 
Dale FyeCommented:
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.
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
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.
0
 
aikimarkCommented:
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.
0
 
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.

/gustav
0
 
JohnCommented:
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.
0
 
shyam pothiniAuthor Commented:
Thanks all for the replies
Is there any way or any software to convert multiple databases at a time?
0
 
Gustav BrockCIOCommented:
Not that I know of. But you could write a looping routine yourself for those databases requiring no code modification.

/gustav
0
 
shyam pothiniAuthor Commented:
Thanks
Looping routine?
How can I do that?
0
 
shyam pothiniAuthor Commented:
Thanks all
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.