bfuchs
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
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
ASKER
Hi,
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
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
Kelvin
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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 ?
What about A2002 ?
ASKER
Hi,
As OP
Thanks,
Ben
As OP
I have Access 2016 and am trying to convert an Access 2003 file to ACCDBI don't have earlier versions to test.
Thanks,
Ben
Kelvin