Avatar of bfuchs
bfuchsFlag for United States of America asked on

Cannot convert MDB file to ACCDB

Hi Experts,
I have Access 2016 and am trying to convert an Access 2003 file to ACCDB and getting file in use error when nobody has the file open except for me...
see attached.
Untitled.png
Microsoft Access

Avatar of undefined
Last Comment
bfuchs

8/22/2022 - Mon
Kelvin Sparks

You need one of the versions prior to 2016. Access 2016 removed the ability to convert mdb's to accdb's. You'll need one of either Access 2007, 2010or 2013 to do this. Once done, then you'll be able to use Access 2016.

Kelvin
ASKER
bfuchs

Hi,

Access 2016 removed the ability to convert mdb's to accdb's.
For what good reason did they do that?!

So I must download a previous version just for this, sounds ridiculous...besides I never liked the mix of versions as it causes trouble, needed to have 2003 as ADP did only work with that had no choice, now I need to add more versions to add to the fun...

And the messages states something else...

I'm trying now to create a new ACCDB file and importing all objects, will see what obstacles will come my way...

Thanks,
Ben
Kelvin Sparks

You can use adp's in later version of Access up to Access 2010 (make not make changes to the code).

Kelvin
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
bfuchs

(make not make changes to the code)
Well, but this is why i need it for...

Thanks,
Ben
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

If you want to upload the db, I will convert it for you ...
ASKER CERTIFIED SOLUTION
Gustav Brock

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.
See how we're fighting big data
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
Fabrice Lambert

At worst, create a new database, and import everything (tables / queries / forms / macros / modules / import and export specs  ...) from the old one.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jim Dettman (EE MVE)

Kevin, you are adding a lot of confusion here. This is no ADP, and Access 2016 can easily both open and convert an Access 2003 mdb file - to both the older 2000 mdb format as well as the accdb format.

 Just to add to gustav's comment a bit, A2013 and up can only open JET 4.0 MDB's (A2000 and A2003).   Support for Jet 3.x and prior (A97 and back) was dropped starting with A2013.   So later versions can't work with all MDB's, but everything up to and including A2019 can work with a JET 4.0 MDB.

 ADP's were entirely dropped with A2013.   You can't use an ADP past A2010.

Jim.
ASKER
bfuchs

The issue here is rather that the file resides in a network folder. Copy the file to a local folder and make a new attempt.
This was the culprit.

Thanks to all participants!
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"A2000 and A2003)."
What about A2002 ?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
bfuchs

Hi,
As OP
I have Access 2016 and am trying to convert an Access 2003 file to ACCDB
I don't have earlier versions to test.
Thanks,
Ben