Hi john,

>Several reasons. The biggest reason is that VFP monolithic apps don't use a server database and with Windows internal buffering and whatnot, duplicate keys are quite possible, especially on peer-to-peer small LANs and/or in heavy traffic.

hmmm, I don't have that experience. To my knowledge if you lock the PK table - record and do a REPLACE pkvalue WITH pkValue+1, the incrementing mechanism should be just fine, even in heavy trafic LANs or whatsoever.

Do you have any references to the described problems ??

Walter,