Thread: Error (File already in use) when converting a .mdb to an .accdb through Access 2010

I'm trying to convert a .mdb file into an .accdb and get the error message, "Could not use '<LOCATION OF THE MDB>'; file already in use." I didn't open any copy of this .mdb, I had only just opened Access and the only thing the file is being used for is to be converted to an .accdb.

I am getting the same error even if I open the database in Exclusive mode and do the convert.

Below were the steps that I followed for the conversion
1. Open Access in 2010.
2. Open the .mdb through file open database option.
3. Switchboard appears. Close the switch board
4. Go to File--Save & Publish--Save Database As(under File Types)--Access Database(*.accdb)(under Save Database As)--Save As (in the bottom)
5. Save as option appears (with the same mdb name but with a .accdb extension)
6. Click save
7. Error appeared.

Am I missing something?

The below work arounds are working fine.

• Open the .mdb by holding down the shift key and follow the above steps 4 to 6 or
• Open a new .accdb and import all the database objects (forms, report, etc.,) from the .mdb that needs to be converted

Anyhelp is highly appreciated

Thanks
Jambai

alansidman,

We are in the process of upgrading all our office 2003 application into office 2010.

True the .mdb files are running just fine under 2007/2010.

No, I am getting the same error even after compact and repair.

But I figured out an other way to do this, and it is working just fine.

• Open the mdb and change the database's start up form to none from switchoard
• Convert it now to .accdb
• Open your accdb, change the database's start up form back to switchboard.

Thank you
Jambai