Tim,

Let me see if I understand the problem first. . .

You have a table with 50,000 records in it.
You start your program (testing) and do a TableUpdate(.T.) after INSERTing 50 new records. In the program that is still running you see that the table now has 50,050 records.
You close the (test) program and using whatever means you now see that the table has only 50,000 - the original number of records before you added any with the test.

I am pretty sure that the above is correct so far, but please advise.

Here's where I get really confused:

1) You say ">So I drop the CDX file and reindex it.
>It works for a while and then the problem happens again.. Does this mean that a REINDEX results in showing the 50 "missing" records?
2) You mention two programs, yet only seem to talk about one. Do you mean that it is the same program on two different workstations or do you mean two different programs?

Also, what is the Server in operation here - OS and version?

Does the program use TRANSACTIONS and, if so, might the END TRANSACTION be being bypassed?

Good luck,

Jim N


>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???