Error converting MDB to Accdb

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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Copy the file to a local folder - like C:\Test - and try again.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
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 (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
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.
Should you be charging more for IT Services?

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!

@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
Consulting
Distinguished Expert 2017
Commented:
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.
Bharat BhushanSolution Manager

Commented:
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
@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 LambertConsulting
Distinguished Expert 2017

Commented:
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 (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
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.
Thanks experts,
However I would still prefer to find the cause of the problem, if someone can figure that out would be great!

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