Transaction problem...

[lidds]

I'm currently writing an application that could potentially have 200+ users obviously being able to do update, insert sql queries to the same database at any given time. I have been reading up on this problem and have been told that using transaction is the way to go? The problem that I have got is 1) finding examples of how to do this and 2) being able to check / set the COM+ service up automatically for my application using code?

 

I was wondering if anyone has done this and would like to share there knowledge and examples if possible. As I am resonably still new to vb.net this is taking me into a new level, but I want this program to be written properly.

 

A bit of info on the systems I am running:

 

vb.net

MSDE (but will be sql server when rolled out)

WinXP and Win2K

 

Cheers

 

Simon