Avatar of Edward Pamias
Edward Pamias
Flag for United States of America asked on

How do I convert Old MS access database to the latest version.

Please excuse the lack of knowledge and possibly wrong verbiage used in this question. My customer has an old access database from 1997 and its been converted to a 2002-2003 format. Now my customer would like to convert this .mdb file to the .accdb format. I have tried everything on google and nothing is working. Is there something I am missing. Be advised, I have no CLUE about Access 2016 or any other version.
DatabasesMicrosoft Access

Avatar of undefined
Last Comment
Edward Pamias

8/22/2022 - Mon
John Tsioumpris

The usual path ...is to create a new blank database in the new version of Access and import everything....then it goes like this :
1. It runs OK ...job finished
2. It doesn't run...then there are a number of reasons why it might not
  • Access bitness : Access 64bit is very restrictive compared to 32bit ...most of ActiveX controls aren't supported and API calls should be "translated" to their 64-bit friendly version (not always)
  • Access and 3rd part drivers : if you use 64bit Access you need 64bit drivers for everything that interacts with your Access...e.g. MsSQL/MySQL...etc
Try step 1 and if you fall in case #2 post back.
Edward Pamias

ASKER
Thanks for the quick response. Both versions are 32 bit.
ASKER CERTIFIED SOLUTION
John Tsioumpris

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jim Dettman (EE MVE)

<<Is there something I am missing.>>

  Access 2013 and up dropped support for anything other than JET 4.0, but that should not be a problem if you truly have it in Access 2000-2002 format.

<<I have tried everything on google and nothing is working.>>

 Detail out what this means...can you open the DB?  It just doesn't run?  Sort of runs? etc

Jim.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Edward Pamias

ASKER
I will close out this questions as resolved. If there is still an issue I will open another questions.

Sorry Jim, I was closing out the question prior to you responding. As for your question to me, meaning I looked at all the google posts tried to do a save as a accdb but nothing shows up in the folder, I even pointed it to another folder and nothing. I am going to try what John suggested on Friday and see how it goes. If that does not work I will open a new question.