Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to unlock a table
Message
From
15/08/2008 03:34:34
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01339075
Message ID:
01339076
Views:
20
What is the OS
>Hi.
>I have an app where there are many users logged in , but every now and then, one of the tables is
> coming up as locked and no apparent reason for it.
>It could be a form is Locking the table (I use Flock() to ensure exclusive access just while appending)
>Could also be a PC thats lost connection to the network (i.e. Hangs) but still seems to lock the table
>Could also be a bug in one of the Forms that is not releasing a lock for sone reason.
>This problem happens maybe once or twice a week in an environment where there are are approx
> 30,000 records written each week
>
>Is there any way to FORCE an unlock on a table , that another user has locked , from within an app?
>
>Any help appreciated
>Regards,
>Gerard
Regards N Mc Donald
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform