>Gee, that's weird. Are you sure everything was good and locked? How often does it happen?
>
>>I have had problems with sequential primary keys generated from an outside table in some NT and Win95 peer-to-peer installations, I think maybe due to the fact that Windows can lie to the app and say something is written while still stuck in buffer, meanwhile other user has already flushed and written.
I was working with an app running at 70 locations, 3-5 concurrent users per. Appx. 10-200 transactions per location per day. Had problems with corrupt (sequential) primary key , on average, 3-20 times a week total.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05