?
Solved

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

Posted on 2014-10-18
7
Medium Priority
?
172 Views
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.
0
Comment
Question by:pabrann
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 58
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.

Jim.
0
 

Author Comment

by:pabrann
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.
0
 

Author Comment

by:pabrann
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.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

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

Accepted Solution

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

Jim.
0
 

Author Closing Comment

by:pabrann
ID: 40417325
Yes, that worked. Thanks Jim!
0
 

Author Comment

by:pabrann
ID: 40417327
Yes that worked, thanks Jim!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

765 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