SHAY
Wed Jan 12 08:57:07 CST 2005
Thanks a lot Andrew .... let me look for the exact code line and get bck to u
. Will it be possible for me to have an email address where i can get bck .
If not I understand and really appreciate ur reply
Shay
"Andrew Howell" wrote:
> SHAY wrote:
> > Hello EveryOne ,
> > I am using FoxFro Dos2.6 , we have a file(DBF.) accesed my multiple
> > people in the office , everything will work fine but soemtimes the
> > file(DBF.) gets locked and won't release unless we reboot . We keep
> > getting the message can't access locked file , press ESc. Please
> > Help as wht could cause the problem or how to solve it .
> > Thanks a lot in advance.
>
> Be aware you will see that message if you do something that requires a
> (possibly implicit) FLOCK and there is a record locked elsewhere [eg do a
> REPLACE ALL whilst someone else is editing a record. You will get the
> message.] The default behaviour for Foxpro is to try to lock indefinately.
> What line of code causes the problem?
>
> Assuming it isn't anything like that; usually quitting the Fox application
> on the clients without the message forces it to release.
>
> If it isn't that, at the very least you should be able to close all
> resources on the server and avoid rebooting the client(s.)
>
>
> I have a table and it occasionally stays locked despite UNLOCK commands in
> the code but that said, I have seen it locked with all clients out of the
> application, in which case I think it's maybe something to do with oplocks
> and/or client caching. There is a fairly through paper on this which you can
> read here
>
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html
>
> --
> HTH
> Andrew Howell
>
>
>