Very Computer

I am trying to run FoxPro 2.0 on a Novell 3.12 server and I am upgrading
workstaions to Windows 95. I can get foxpro to run but I am having a problem
with file locking. I can use a file once and when I go to access it again, it
says that is in use by another person. Data & EXE on the server.

Help. If I can't solve this one there may be an opening for an Analyst in
Buffalo!!!

Chuck

Chuck:

Flag all the data, index, mem files etc. SRW
FLAG *.DBF SRW
FLAG *.CDX SRW
FLAG *.FPT SRW

Flag the EXE FXP APP files etc SRO

SET EXCLUSIVE OFF very early in your code so that more than one user can
use files. Check out SET REPROCESS as to how record locking is handled.

Make sure each user has a copy of their own resource file in their own
home directory or on their local machine, FOXUSER or what ever you have
set up.

That should do it. Good luck

Raj
Remove UNDERWEAR if replying directly

Firstly for speed reasons try the exe on the local stations.
Check your user rights on the server
 Check the status of the files on the server using the flag command as
Flag *.db? rw
Flag *.fpt rw

Check the set exclusive option is set to off on the config.fp and isn't
being reset to on in a program.   Check that you haven't set an flock or
rlock and left them on.
Check that the config.sys on the workstation has a files=200 statement
Make sure that you use the Microsoft Netware Client and not the Novell
client

Thats about all I can think of at the moment.

I am running a big suite of foxpro dos 2.0  and FoxproW26 programs to Novell
3.12 servers with no problems so there are solutions to your current drama
<g>

Al.

Quote:>Help.

>I am trying to run FoxPro 2.0 on a Novell 3.12 server and I am upgrading
>workstaions to Windows 95. I can get foxpro to run but I am having a
problem
>with file locking. I can use a file once and when I go to access it again,
it
>says that is in use by another person. Data & EXE on the server.

>Help. If I can't solve this one there may be an opening for an Analyst in
>Buffalo!!!

>Chuck

chances are the file has been left open and when you try to use it again you
are getting a "file in use" error. If that is the case try putting the file
opening code in an if statement like:
if used('<file name>')
   select <file name>
else
  use <file name>
endif

If you do have other users and the code wasn't written with multi users in
mind you have a moderately large task ahead of you. You need to set
exclusive off, then lock all records when updating them and lock files when
doing global updates.

Best of luck...

Dick Walker

(remove nospam.)

Quote:> Help.

> I am trying to run FoxPro 2.0 on a Novell 3.12 server and I am upgrading
> workstaions to Windows 95. I can get foxpro to run but I am having a
problem
> with file locking. I can use a file once and when I go to access it again,
it
> says that is in use by another person. Data & EXE on the server.

> Help. If I can't solve this one there may be an opening for an Analyst in
> Buffalo!!!

> Chuck