Cannot convert MDB file to ACCDB

bfuchs
bfuchs used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
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
You can use adp's in later version of Access up to Access 2010 (make not make changes to the code).

Kelvin
Ensure you’re charging the right price for your IT

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

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

Thanks,
Ben
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
If you want to upload the db, I will convert it for you ...
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
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.
Fabrice LambertConsulting
Distinguished Expert 2017

Commented:
At worst, create a new database, and import everything (tables / queries / forms / macros / modules / import and export specs  ...) from the old one.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
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.
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 - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
"A2000 and A2003)."
What about A2002 ?
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial