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
LVL 6
bfuchsAsked:
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.

Kelvin SparksCommented:
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
0
bfuchsAuthor Commented:
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
0
Kelvin SparksCommented:
You can use adp's in later version of Access up to Access 2010 (make not make changes to the code).

Kelvin
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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

Thanks,
Ben
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
If you want to upload the db, I will convert it for you ...
0
Gustav BrockCIOCommented:
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.

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.
Or, the mdb file is in an older format - if so, first convert it to 2000 or 2003 format.
0

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
Fabrice LambertFabrice LambertCommented:
At worst, create a new database, and import everything (tables / queries / forms / macros / modules / import and export specs  ...) from the old one.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
1
bfuchsAuthor Commented:
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!
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"A2000 and A2003)."
What about A2002 ?
0
bfuchsAuthor Commented:
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
0
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.