<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=US-ASCII">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY><!-- Converted from text/plain format --><FONT size=2>
<P><BR><BR>> -----Original Message-----<BR>> From:<BR>>
filepro-list-bounces+gccconsulting=comcast.net@lists.celestial<BR>>
.com<BR>> [<A
href="mailto:filepro-list-bounces+gccconsulting=comcast.net@lists.c">mailto:filepro-list-bounces+gccconsulting=comcast.net@lists.c</A><BR>>
elestial.com] On Behalf Of Don Coleman<BR>> Sent: Wednesday, July 25, 2007
10:04 AM<BR>> To: filepro-list@lists.celestial.com<BR>> Subject:
Identifying who has a record locked on Windows network<BR>><BR>>
List:<BR>><BR>> I probably already know the answer to this but I'll ask
anyway.<BR>> On a Windows network (WIN2000 Advanced Server, Windows 2000
&<BR>> WINXP Pro.<BR>> Clients, fP v5.0.13 64 user license), is there
anyway, within<BR>> the Windows tools or using an external utility, to
identify<BR>> which user or work station (I'd take either) has a
particular<BR>> fP record locked in a file?<BR>><BR>> Most nights, when
my client is finishing their last few<BR>> delivery sheets (packing slips)
there is typically 1-2<BR>> facilities that they cannot process/print due to
a locked<BR>> record. Since time is of the essence at this time of
the<BR>> evening (FEDEX waits for no one) the supervisors don't have<BR>>
time to walk around a large multi-floor building and check<BR>> who may be
sitting in the update mode on a record for that<BR>> customer. The
customer (1 is<BR>> complaining) is tired of having their delivery sheet
faxed to<BR>> them the next day. They just want it included in
their<BR>> order. They can always print it the next day because
whoever<BR>> had the file locked was knocked off at midnight when the<BR>>
network share is disabled for maintenance.<BR>><BR>There is a way to see who
is still accessing fileopo from the server.<BR><BR>This may not indicate who is
locking the particular record. See below:</P>
<P>This is a screen shot from my server and shows the files I have open.</P>
<P><IMG height=429 src="cid:906213316@25072007-079D" width=860></P>
<P><FONT face=Arial color=#0000ff>If someone is shown to have an open file such
as the second to last item listed, and they are not supposed to be on the
system, you have several options, if they are still working, contract them
and advise them to get out of the system, have someone go to their desk
and manually exit them from the system or lastly but not the best way,
end the session by right clicking and select "close open
file". </FONT></P>
<P><FONT face=Arial color=#0000ff>I ran a test on this option:</FONT></P>
<P><FONT face=Arial color=#0000ff>Opened Word and loaded a letter from the
server. That file showed as an open file. Right clicked and took the
option to clode the file. The file was closed on the server but remained
in my workstations memory. When I exited Word, it asked me if I wanted to
save the file. I did and the small modification I made was still there
when reopened. </FONT></P>
<P><FONT face=Arial color=#0000ff>Won't guarentee what will happen with a
filepro file as I haven't test closing a key in this manner.</FONT></P>
<P><FONT face=Arial color=#0000ff>You also have the option of loggin someone off
from the sessions folder. I have has to use this option a few time from
terminal server when a user has timed out and not logged off, leaving there
session connected and I needed to modify a file structure.</FONT></P>
<P><FONT face=Arial color=#0000ff>My suggestion is to use a test file and test
closing the file when viewing a record, when in update mode on a record and when
adding a new record to se the how the file is affected.</FONT></P>
<P><FONT size=2>Richard Kreiss<BR>GCC Consulting<BR> </FONT> </P>
<P><FONT face=Arial color=#0000ff></FONT> </P>
<P><FONT face=Arial color=#0000ff></FONT> </P>
<P><FONT face=Arial color=#0000ff></FONT> </P>
<P><FONT face=Arial color=#0000ff></FONT> </P></FONT></BODY></HTML>