Solved

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

Posted on 2014-10-18
7
167 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
  • 5
  • 2
7 Comments
 
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.

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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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 57

Accepted Solution

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

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

813 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

16 Experts available now in Live!

Get 1:1 Help Now