Hi, Everyboday,

We have an application that allows multiple users (40+) from their workstations to access a VFP database that is located on a network server.

Lately, the users have been complaining that they are losing data (records). As I checked the error log table that we created to track errors occoured. There are many error # 108 entries, which states that the "File is in use by another user".

When I checked the code where the savings occurs, the basic process is as follows:

set reprocess to automatic
public gnError
m.gnError = 0 
on error m.gnError = error()
begin transaction 
insert into stafile (...) values (...)
if m.gnError = 0 ;
then 
   end transaction 
else 
   rollback 
endif 

The form that excecutes that code has BufferMode set to 0.
The stafile has buffering set to 1 (no buffering).
To solve the problems I have changed the above code to the following:

set reprocess to automatic
public gnError
m.gnError = 0 
on error m.gnError = error()
use aprdb!stafile in 0 order sta_id 
begin transaction 
if rlock("0",'stafile') ;
then 
   insert into stafile (...) values (...)
   unlock record 0 in stafile 
endif 
if m.gnError = 0 ;
then 
   end transaction 
else 
   rollback 
endif 

The users are still losing data and they are really getting fed up with it.
The record count in stafile is 1.2+ mil. and fields count is 51, total field length is 421.

Any comments will be appreciated greatly!

Dawa