Forum Discussion
JerryHeck
Jul 13, 2020Copper Contributor
Access 97 conversion to current technology
Hello, I wrote an Access 97 database 20 years ago for a friend who owns an HVAC business. He contacted me recently and would like it upgraded to current technology. I have a lot of VBA written int...
George Hepworth
Jul 13, 2020Iron Contributor
JerryHeck You can migrate it to the current version of Access with a minimum of design changes probably.
To upgrade from 97, you will have to go through an intermediary version. I think Access 2003 will handle that. Then you can further update it with Access 365, or Access 2019 Professional.
Depending on what you did in the original mdb, you may have to replace things like calendar controls with current alternatives.
The ribbon is totally different from the old menu system. That will require some attitude adjustment as well as re-learning. ![]()
However, I would think that Access remains the right choice for a facelift.
- JerryHeckJul 14, 2020Copper Contributor
George Hepworth Thank you for your reply.