Yes, I guess it makes sense to consider the context when making the choice concurrency vs integrety.

Thanks for the help guys, much appreciated.

SSChampion>>

Theoretically, the possibility exists even with only 2 users in a system. Shouldn't one assure that this cannot happen, or what is best practice? It looks to me that integrety...

Would moving the trans not create an integrety problem in that someone could update the AccountType in between the checking and inserting?

I tried to circumvent this by adding the...

Yes, I would definitly have to add some error checking after the insert statement.

The reason why I ask is because i am reading up on the subject and scalability seems...

You are better of starting a new thread since I cannot help you with your problem.

Cheers,

Could you be a little more specific? I can't see the relation here...

This maybe not be a surpise, but you need to make a host for the dll.