Updating ms access database
In many instances conversion errors result from poor implementation in the original database, something with which a push-button conversion is not going to cope.
You might want to talk to me before you press the button or if you want help with programming in general.
The conversion of an out-of-date database to the latest version of Microsoft Access is, very rarely, a straightforward or error-free process.
I can assess your Access databases for what it will take to convert them; can perform the conversion for you; and will be pleased to work with you if you want to include improvements as part of the process.
I’ve tried one unlocker program that gets mentioned a lot on the web.
In those Access MDEs that I’ve “unlocked” using it, the conversion did not go perfectly and none of the VBA code residing in modules became accessible.
Even if you complete the process, not all conversion errors get logged as part of the process.
Please contact me if you need help addressing some of the resulting issues.
If now you’re upgrading to Access 2013, 2016 or 2019, or short-term to 2010, then you may have many ideas about improving it for its users and for gaining more out it in pursuit of improved business performance.
Access 2007 introduced new file formats — including “.accdb” — none of which would accommodate user-level security.
So conversion of a secured database can throw up some challenges.