Hi!
I am faced with a frustrating and hard to figure out problem...

Here's the problem...
Some clients use two program which access
the same DBF file called PDMLOG.DBF

One client program inserts records into the PDMLOG
and then the server application reads it and transfers it to AS400 if necessarry.

Most of the time it works but sometimes when the records
get inserted into the table in the client program
the server program can't see these new records.

I opened up the table in foxpro and noticed the
following.

In the application there are 50050 records with some data I put in to test...
I do a tableupdate(.t.)

But in foxpro there is only 50000 records.

When I close the program the data is lost.
When I come back in only 50000 records remain.

So I drop the CDX file and reindex it.
It works for a while and then the problem happens again.

Any ideas???