Locking may be a good option but the performance to integrity tradeoff .....<br>Locking might also frustrate users when trying to insert<br><br>Anyway, I think i&#39;ll use a different way of getting the primary key other than relying on the last insert<br>

Or maybe employ the use of a surrogate key<br><br>I&#39;ll research on the matter then share the best solution in my view<br>