Client / Server Database application

[hafizfarooq]

Hello,

I want to clear something about Client Server Database application using Visual Basic 6.0 and SQL Server 2000 and ADO.

Is there any difference in Opening Recordset from the following ??

Set Rs = New ADODB.Recordset
With Rs
        .Open "Select * from Tbl_Class_Reg where Class_Code = '" & TxtCode & "'", dB, adOpenDynamic, adLockOptimistic
End With

If any difference then what is that ?

What is Locking ??? Why we use it ??

Do we need 2 different softwares fro the same work for Clien and Server ? or just Install 1 software on server and open it from client ?

Please help me. Any code or application with code will be appriciated

Farooq