Creation of RecordSert as a Server-side Recordset and Client-side Recordset in Visual Basic

The following code is for creating a Server-side Recordset.
Option Explicit
Dim CN As Connection
Dim comobj As Command
Dim rs As Recordset
Private Sub Form_Load()
Set CN = New Connection
Set comobj = New Command
Set rs = New Recordset
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseServer
With CN
.ConnectionString = “Integrated Security=SSPI;Initial Catalog=FinAccounting;Data Source=SYS1”
.Provider = “SQLOLEDB”
.Open
Option Explicit
Dim CN As Connection
Dim comobj As Command
Dim rs As Recordset
End [...]

Types of Recordsets in Visual Basic

A resultset  returned from a database server as a result of the execution of an SQL statement can be stored in a Recordset object for further manipulation. In other words, a Recordset object can manipulate data returned by a provider. All Recordset objects consists of records (rows) and fields (columns).
There are 4 types of  recordsets
Dynamic [...]