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