Access 97 conversion to current technology

%3CLINGO-SUB%20id%3D%22lingo-sub-1518918%22%20slang%3D%22en-US%22%3EAccess%2097%20conversion%20to%20current%20technology%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518918%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20wrote%20an%20Access%2097%20database%2020%20years%20ago%20for%20a%20friend%20who%20owns%20an%20HVAC%20business.%26nbsp%3B%20He%20contacted%20me%20recently%20and%20would%20like%20it%20upgraded%20to%20current%20technology.%26nbsp%3B%20I%20have%20a%20lot%20of%20VBA%20written%20into%20it.%26nbsp%3B%20I%20need%20it%20to%20work%20with%20multiple%20users%20in%20a%20small%20office.%3C%2FP%3E%3CP%3EI%20retired%20from%20software%20development%20about%203%20years%20ago%20and%20haven't%20kept%20up%20on%20latest%20trends.%26nbsp%3B%20What%20would%20this%20community%20suggest%20for%20a%20conversion%20path%20to%20a%20current%20technology%20without%20a%20complete%20rewrite.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1518918%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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 into it.  I need it to work with multiple users in a small office.

I retired from software development about 3 years ago and haven't kept up on latest trends.  What would this community suggest for a conversion path to a current technology without a complete rewrite.

Thanks

2 Replies
Highlighted

@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. :happyface:

 

However, I would think that Access remains the right choice for a facelift.

Highlighted

@George Hepworth Thank you for your reply.