We help IT Professionals succeed at work.

Cannot convert MDB file to ACCDB

bfuchs
bfuchs asked
on
155 Views
Last Modified: 2018-10-11
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

CERTIFIED EXPERT

Commented:
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
CERTIFIED EXPERT

Author

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
CERTIFIED EXPERT

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

Kelvin
CERTIFIED EXPERT

Author

Commented:
(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
CERTIFIED EXPERT
Top Expert 2007

Commented:
If you want to upload the db, I will convert it for you ...
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Fabrice LambertConsulting
CERTIFIED EXPERT
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
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

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.
CERTIFIED EXPERT

Author

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!
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"A2000 and A2003)."
What about A2002 ?
CERTIFIED EXPERT

Author

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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.