Error converting MDB to Accdb

Hi Experts,

I'm trying to convert an Access MDB file to accdb and getting the attached error "file already in use".
However I dont know of any other way of converting it w/o opening.
When I tried save as w/o a file Access crashed..
FYI- I'm using A2016 for the conversion.
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.

Gustav BrockCIOCommented:
Copy the file to a local folder - like C:\Test - and try again.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
or make sure there is no .LDB file in the directory.

 Also, make sure the app complies if it has any code in it before converting (that's not your issue though).

Jim.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Also be aware that Access 2013 and up can only convert JET 4.0 and up.  

 If this is an older DB format, I can convert it for you.

Jim.
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

bfuchsAuthor Commented:
@Gustav, I did try that and same occurs.
@Jim, This is a A2003 FE application.
Only LDB is the one that gets created when I open the file as OP.
Thanks,
Ben
Fabrice LambertConsultingCommented:
Hi,

At worst, create a new database (accdb), and import everything (tables, queries, macros, VBA modules, VBA class modules) from the old to the new one (simple drag & drop with both databases open).
Set startup options, custom properties, VBA references ect ... and it shoud be fine.

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
Bharat BhushanSolution ManagerCommented:
I do not know, how you are converting but it's locked. Check your task manager and see if you have two instances open.

If save as causes a crash then, you better check the References in the MDB file because it might be that.  If not, it might have some bad code that will not run if upgraded
bfuchsAuthor Commented:
@Bharat,
Nothing is opened according to task manager.
What I meant it crashed is when opening just A2016 and selected save as w/o having any file open..

So far the only way I was able to get this was by importing as Fabrice suggested..(although the drag & drop didnt seem to work for me..-:)
Any other suggestions before closing this question?

Thanks,
Ben
Fabrice LambertConsultingCommented:
If drag & drop fail, you can export objects (right click, choose export) to text or XML format, and import into the new database.

Warning with tables holding binary data (such as memo fields or attachments), this might not work correctlty.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Compact and repair with A2003 first, then a /decompile, and then try a convert/import.

The other thing to try would be an import into a clean MDB file with A2003 first, then a convert with A2016.

If that all fails, then a saveastext/loadfromtext on all the objects.

Jim.
bfuchsAuthor Commented:
Thanks experts,
However I would still prefer to find the cause of the problem, if someone can figure that out would be great!
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.