Hello Mark,

I know that is the article you were talking about. The method in that article won't hold up under pressure.

You start one sentence with "The usual keytable methods lock", then the next sentence (in another paragraph) with "that is not possible", so I was trying to understand what the word "that" was referring to <s>

The referral to Craig's website was free ;)

>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.
>>>