Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Drive in Use error

Posted on 2013-05-24
3
Medium Priority
?
187 Views
Last Modified: 2013-05-29
I am converting from 2003 to 2010.  I am getting an error "Could not use O;\.... drive in use".  It is not that the database is open as I checked for ldb file.  Is there anything else I can check.
0
Comment
Question by:leezac
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 39195535
< I am getting an error "Could not use O;\.... drive in use".>
When you do what, specifically?

If in addition to you upgrading from 2003 to 2010, your Network configs may have also changed.

Check with your Network Admin to make sure that path:
O:\....
...is valid and that you have full permissions to it.
0
 

Author Comment

by:leezac
ID: 39195567
Will repost again next week - getting ready for long weekend.  The code in the VBA saves the file to the drive with a date in the name when a button is clicked.  Now someone not converted did have the file open.  I will also check again to see if he can save file again as we did not test that today, because I did not think of it.

 He can save a word doc to the file folder.  I had him check.  I googled that permission may be an issue.  I am stumped.
0
 

Author Comment

by:leezac
ID: 39202036
I found out more that they are using the Quick Access Toolbar to try to save the database and that is when they get the error.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

824 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