Help: Cant delete Access LDB file!

  • Thread starter Thread starter VB Programmer
  • Start date Start date
V

VB Programmer

I have an ASP.NET website that uses Access. I want to replace the Access
file but the LDB (locking) file will NOT go away so I can't replace it. (I
think maybe in one of my previous pages I opened a db connection without
closing it maybe???)

How can I delete the LDB file so that I can replace the MDB file? Any
suggestions? I don't think restarting the webserver is an option.

Thanks!
 
You will have to find the process that has it locked (most likely aspnet_wp)
and kill it. You will then be able to get rid of it. NOTE: If you, or
someone else, also have access open, that is where the lock file comes from.

Restarting the machine, as a worse case, should clear everything up.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
 
¤ I have an ASP.NET website that uses Access. I want to replace the Access
¤ file but the LDB (locking) file will NOT go away so I can't replace it. (I
¤ think maybe in one of my previous pages I opened a db connection without
¤ closing it maybe???)
¤
¤ How can I delete the LDB file so that I can replace the MDB file? Any
¤ suggestions? I don't think restarting the webserver is an option.

Try stopping your web server process.

BTW, you don't need to replace it, simply delete it.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Won't this shut down all websites on the machine being run by IIS? This is
not an option at the moment unfortunately. :(

Any further ideas?

Thanks.

 
Will the webserver have to be restarted after this? Or will pulling up an
ASPX page on my local browser start the process again?

Thanks.
 
I killed the aspnet_wp.exe and then I could delete it. Thanks y'all.

VB Programmer said:
Won't this shut down all websites on the machine being run by IIS? This is
not an option at the moment unfortunately. :(

Any further ideas?

Thanks.
Click to expand...
 
Back
Top