Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

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

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
pabrann
Asked:
pabrann
  • 5
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
pabrannPresidentAuthor Commented:
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
 
pabrannPresidentAuthor Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
pabrannPresidentAuthor Commented:
I tried to do this without opening the source database but the "Save & Publish" is disabled until I open it.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Make a copy of it and run a compact and repair on it.  Then try converting that copy.

Jim.
0
 
pabrannPresidentAuthor Commented:
Yes, that worked. Thanks Jim!
0
 
pabrannPresidentAuthor Commented:
Yes that worked, thanks Jim!
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now