Trying to convert 2003 mdb mode database to default 2010 mode, "file already in use" message

Posted on 2014-10-18
Last Modified: 2014-11-01
I'm trying to convert a 2010 access database running in 2003 mode to default 2010 format. I'm getting a message that the database is already in use and the conversion fails.
Question by:pabrann
  • 5
  • 2
LVL 57
ID: 40388888
Close all your DB's and Access and make sure there are no .LDB files in the directories where the DB's are.  If there are, delete them.  If you can't delete them, reboot and then delete.


Author Comment

ID: 40388896
Hi Jim,  I created a new folder with only 1 file to do this. Although, when the procedure is executed the file is open. But the question is asked if I want Access to close the database and I select "yes". It appears that is is not being closed as requested.

Author Comment

ID: 40388900
I have even tried selecting a different destination location to create the new database that has no files and it still generates the error.
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline


Author Comment

ID: 40388918
I tried to do this without opening the source database but the "Save & Publish" is disabled until I open it.
LVL 57

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40389078
Make a copy of it and run a compact and repair on it.  Then try converting that copy.


Author Closing Comment

ID: 40417325
Yes, that worked. Thanks Jim!

Author Comment

ID: 40417327
Yes that worked, thanks Jim!

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now