Re: Good ways to tell why a dbf is locked?
- From: Cy Welch <cywelch@xxxxxxxxx>
- Date: Thu, 08 Feb 2007 17:06:18 -0800
Steve Hershoff wrote:
I'm sure everyone's seen those messages when trying to select records from a dbf- "File access is denied". Are there any good tools out there to see what process has the file locked? Are there Foxpro-specific utilities to unlock them if it comes to that? I realize the latter has some risk involved but when you're desperate...A lot of it depends on where the file is. Also the message can come from more than one cause depending on the version of FoxPro. With (I believe) VFP8 and higher the default is to attempt to lock the header of the table as it opens it, and you will get this error if the lock fails. This same lock also occurs by default for several other functions, and if more than one is happening (or multple copies of VFP are opening the table at the same time) this error can occur.
If the files are local, look at process monitor at http://www.microsoft.com/technet/sysinternals/FileAndDisk/processmonitor.mspx which will give you that information. I'm not sure off the top of my head if it can close them if their open, but it will show you what process has them open.
If the files are on the network and you have the right priviledges, you can check the files in use on the server to see what workstation(s) have them open.
--
Cy Welch
Senior Programmer
MetSYS Inc
http://www.metsysinc.com
.
- References:
- Good ways to tell why a dbf is locked?
- From: Steve Hershoff
- Good ways to tell why a dbf is locked?
- Prev by Date: Re: Program on a flash Drive
- Next by Date: Re: New buffer overrun info
- Previous by thread: Good ways to tell why a dbf is locked?
- Next by thread: New buffer overrun info
- Index(es):
Relevant Pages
|
