I am final yr student and am working on a proj for a school and have a doubt regarding the sql connection...

well, in order to establish a client server system it is essential to maintain mutual exclusion (no two write permissions to the same table on a database...). for this

set con = new ADODB.Connection
set rs = new ADODB.Recordset
.
.
.
.
.
rs.open "select * from table", con, adOpenDynamic, adLockOptimistic


I am not sure if adOpenDynamic, adLockOptimistic are the right combination for that...please help me out...its urgent...the abouve is what I have used ..my submission date is closing in...Thanxs