• 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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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