Hi Steve


Wires crossed here I think:)
We are talking about a UT Article called

The Easy Way to Form a Primary Key

Not Craig's proggy :)


>Mark,
>
>Are you saying the "usual" method of locking the record is not possible in a multi-user environment? The lock would be *very* brief, only when a record is added. If the user decides to edit the new record, there shouldn't be a problem.
>
>However, the method on Craig Berntson's website briefly locks the entire key table, and from what I understand that code has proven to be reliable in heavy multi-user systems.
>
>>
>>I was a bit suspicious about that myself. The usual keytable methods lock the record in the keytable briefly to guarantee a unique key is returned.
>>
>>That would not be possible in a muti user environment because a user might be editing the latest record.
>>