Use a Application level variable as your incremental value.
(Select MAX(increment) FROM yourtable at application startup.)

Then when you need to increment the primary key,
APPLICATION.LOCK
increment=increment+1
retrn_increment=increment
APPLICATION.UNLOCK

>Thanks for the reply, but it appears that Application.lock
>only locks changing the properties of the application object,
>and does nothing about locking a table.
>Jim

>>You can use ASP's Application Lock feature to lock the system,
>>retreive a new pk, then application unlock.