Solved

CANNOT DELETE DB1: ACCESS IS DENIED.  THE SOURCE FILE MAYBE IN USE.

Posted on 2004-08-04
6
1,160 Views
Last Modified: 2008-02-01
CANNOT DELETE OR MOVE A DB1 FILE THAT WAS CREATED UPON AN INVALID EXIT OF THE DATABASE.

WHAT CAN I DO TO GET RID OF THIS FILE?
0
Comment
Question by:whosoever
6 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 50 total points
ID: 11720966
You likely have a "Locking File" ... look in the same directory as the errant database for a file with an .ldb extension (it'll be named the same as the database, so a database named Bob.mdb would have a locking file named Bob.ldb). Delete that file and you should be able to delete your database.
0
 
LVL 84
ID: 11720974
Oh, and remove the Caps Lock from your keyboard ... it's hard enough to read this stuff 18 hours a day without having to decipher all caps!!!
0
 
LVL 17

Assisted Solution

by:walterecook
walterecook earned 100 total points
ID: 11721042
you're working with Access?

(and who knows, perhaps his job IS AS A P.A. SYSTEM!)

Walt
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:whosoever
ID: 11721162
no locking files files are present in the directory that this resides in.
0
 
LVL 17

Expert Comment

by:walterecook
ID: 11721417
I'd try to do it after a fresh reboot.  I'm guessing that some process (possibly hidden process) still has it or thinks it has it and thus you can't get it.

Walt
0
 
LVL 36

Accepted Solution

by:
SidFishes earned 100 total points
ID: 11721830
walts solution works....but sometime you can't reboot conveniently...you can also try looking at control panel/administrative tools/computer management/shared folder/open files

right click on open file to disconnect
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 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