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