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?
whosoeverAsked:
Who is Participating?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
walterecookCommented:
you're working with Access?

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

Walt
0
 
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
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.

All Courses

From novice to tech pro — start learning today.