Link to home
Start Free TrialLog in
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
Avatar of Kelvin Sparks
Kelvin Sparks
Flag of New Zealand image

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
Avatar of bfuchs

ASKER

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
Avatar of bfuchs

ASKER

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

Thanks,
Ben
If you want to upload the db, I will convert it for you ...
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
At worst, create a new database, and import everything (tables / queries / forms / macros / modules / import and export specs  ...) from the old one.
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.
Avatar of bfuchs

ASKER

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!
"A2000 and A2003)."
What about A2002 ?
Avatar of bfuchs

ASKER

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