Updating to a newer .mdb database

what is the best process to important a .MDB database from access 97 into a current database system. Im not sure what other questions I should be asking however I need to migrate over from access 97 database store to a more up to date system

Suggestion?
cmdolcetAsked:
Who is Participating?

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

x
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.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Access 2013 (and 2016) will no longer recognize and Access 97 mdb. So, you will need to find an Access 2010 (or 2000/2002/2003) system and first convert to that format, then proceed to convert to A2013 or A2016.
So ... you need to get past this hurdle first ...

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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Once you get the A97 db into (ideally) A2010 ... and get it operation in A2010 - meaning all References are working and your VBA code compiles ... then ... create a blank A2013/A2016 container, and import all of your objects into that container and continue on ...

At the moment, I would not recommend A2016 - as we are finding there are several bugs that need to be resolved my Microsoft.
Gustav BrockCIOCommented:
You can do it in two steps.
Use Access 2000 to convert to Access 2000 and Jet4.
This you can convert directly with Access 2013 to the ACE (accdb) format.

/gustav
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
1. Make a backup copy.
2. Compact and Repair.
3. Ensure that it compiles.
4. Convert.
5. Compile again and check for errors.   Some things that you may have used like the MS calendar control have been removed and replaced with something built-in.
6. Test app functionality.

Jim.
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
Microsoft Access

From novice to tech pro — start learning today.