bfuchs
asked on
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
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
Copy the file to a local folder - like C:\Test - and try again.
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.
Also, make sure the app complies if it has any code in it before converting (that's not your issue though).
Jim.
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.
If this is an older DB format, I can convert it for you.
Jim.
ASKER
@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
@Jim, This is a A2003 FE application.
Only LDB is the one that gets created when I open the file as OP.
Thanks,
Ben
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
@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
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
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.
Warning with tables holding binary data (such as memo fields or attachments), this might not work correctlty.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks experts,
However I would still prefer to find the cause of the problem, if someone can figure that out would be great!
However I would still prefer to find the cause of the problem, if someone can figure that out would be great!