Experts advice on ADO Connection

[ayh8disjob]

Hi Everyone I need an experts advice on this matter
Keys
adOpenKeyset,adOpenStatic,adOpenDynamic
Lock
adLockReadOnly,adLockOptimistic,adLockPessimistic

Which is best combination to to open a database
that i will use in a multiuser client-server environment?
lets say the screnario is
30 or more Users with SQL server database backend
Screnario are as follows:
1. some will just view a record
2. while others will modify a record
3. while others will try to delete a record

What is the best combination to secure my data
when I open recordset in each screnario?

hope you could help me thanks in advance!

 

[softwarescience]

Hello

Generally if you are only reading data then use adOpenStatic and adLockReadOnly
and if you are updating a record then adOpenDynamic and you will have to decide if you want pessimitic or optimistic locking as this is more dependent on whether you use transaction processing and how many people will be updating concurrently but for safety use adLockPessimistic.

Hope this helps