record is being updated - access denied

Scott Walker scottw1 at alltel.net
Fri Jul 20 14:35:06 PDT 2007


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




More information about the Filepro-list mailing list