• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1206
  • Last Modified:

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

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
whosoever
Asked:
whosoever
3 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
walterecookCommented:
you're working with Access?

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

Walt
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
whosoeverAuthor Commented:
no locking files files are present in the directory that this resides in.
0
 
walterecookCommented:
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
 
SidFishesCommented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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