ok i'll take a look at it.

pwellink,

but in theory it should lock the table until the end of the transaction, right? so there should be no problem.

Another thing is that this works on a single processor...

tblOrderNumber will only contain one row. Initially I insert a value, say OrderNumber=1. Then after that, all access to the data would be update and select - this would be...