Access Denied

[Kenneth Brody]

On 2/16/2016 5:06 PM, Richard Kreiss wrote:
> Having an odd problem - my client recently moved his application to a new
> server and has run into a problem where one record is locked and causes a
> task to hang.
>
> This person's record was last accessed almost 10 years ago except by
> reports which are run daily. (Record Is being Updated - Access Denied).
>
> I am not sure if this is a filePro message or a system message.  The
> server can be rebooted tonight after midnight if this is a OS lock.
> (Windows Server 2012).
>
> Anyone have a suggestion as to why this record would be locked when no
> one is accessing it?

"Record is being updated - access denied" means that filePro requested the 
record to be locked, but the system returned an error that the record was 
already locked.

Unfortunately, there is no way that I know of to enumerate locks on a file 
on Windows.

There is a utility, "WhoHasOpen.exe", which I believe is now included in the 
filePro distributions.  If not, fpsupport can send you a copy.  It won't 
show what locks are on a file, but it will show you which processes have a 
file open.  Simply run it on the file's "key" file, and see if there are any 
processes that you didn't know about.  (Get everyone out of filePro first, 
if you desire.)

-- 
Kenneth Brody