record is being updated - access denied

[Dennis Malen]

Thanks for your response.

I wish it was as easy as that. We use the kill feature more than just 
periodically. With everyone logged off there is no processing for us to 
kill.

Dennis Malen
516.479.5912
----- Original Message ----- 
From: "Scott Walker" <scottw1 at alltel.net>
To: "'Dennis Malen'" <dmalen at malen.com>
Cc: "Filepro_List" <filepro-list at lists.celestial.com>
Sent: Friday, July 20, 2007 5:35 PM
Subject: RE: record is being updated - access denied


> Dennis,
>
> Do you understand the difference between a file being locked by filePro
> and a record being locked by a filePro process?  If not, then you must
> first understand this or you will forever be in the dark as to how
> filePro works on your multiuser operating system.
>
> The situation you are describing is a locked record.  It has NOTHING
> WHATSOEVER to do with filePro's "lockfile".  Perhaps a user starts to
> update a customer file record.  That locks the record.  If that user
> then drops their connection to the server (in some abnormal fashion) the
> process they were running (the rclerk program that was updating the
> customer file record) can be left running & thus does not release the
> lock on that customer file record.
>
> You can simply kill that process (using your operating system "kill"
> command with the appropriate process id number.  That will unlock the
> record.  There is no need to reboot unless you have no idea how to find
> and kill an orphan process in which case a reboot does it for you.
>
> Regards,
>
>
> Scott
>
>
> Scott Walker
> RAM Systems Corp.
> ScottWalker at RAMSystemsCorp.com
> Ph: (704) 896-6549
> Fx: (704) 896-7458
>
>
> -----Original Message-----
> From: filepro-list-bounces+scottw1=alltel.net at lists.celestial.com
> [mailto:filepro-list-bounces+scottw1=alltel.net at lists.celestial.com] On
> Behalf Of Dennis Malen
> Sent: Friday, July 20, 2007 5:22 PM
> To: filepro-list at lists.celestial.com
> Subject: record is being updated - access denied
>
> We are sitting in a file on one record which islocked. We want to either
>
> delete or update and we get the message that:
>
> "Record is being updated - Access Denied"
>
> We can fix the problem by a fast reboot which we don't want to have to
> do.
> Is there any other way to unlock the file other than going into ?-
> filePro
> Directory in the Main Menu and press "delete formats" and pressing M-
> Lockfile?
>
> Lastly, we had everyone log off the system and accessed M- Lockfile,
> which
> had no effect.
>
> This problem occurs periodically (one every couple of months)which
> eventually forces us to reboot.
>
> Any suggestions?
>
> Dennis Malen
> 516.479.5912
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>
>