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

What buffering are you using? I hope it's 5-optimistic table buffering. Have you tried checking by SET DELETED OFF then browse to see if records are not deleted?