Fox will send the changes to the server when either the table is closed or a FLUSH command is issued. It's possible that the server is buffering those changes. However, I agree with Wayne that you should not use RECNO() as the key. Look at the Primary Key article on my web site for a procedure that works.

BTW, I lived in Randolph about 12 years ago. How are things there?


>At what point does FoxPro commit a record to the table.
>
>I have two users on the network hit the following code at the same time and I am getting duplicate ID's; but two different records.
>
>Select TableA
>Append Blank
>Replace ID with RecNO()
>
>Thank you.
>Neetu