Solved

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

Posted on 2014-10-18
7
166 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

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.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

914 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