You use Recordset objects to manipulate data from a 
provider. When you use ADO, you manipulate data almost 
entirely using Recordset objects. All Recordset objects 
consist of records (rows) and fields (columns). Depending 
on the functionality supported by the provider, some 
Recordset methods or properties may not be available.

ADODB.Recordset is the ProgID that should be used to create 
a Recordset object. Existing applications that reference 
the outdated ADOR.Recordset ProgID will continue to work 
without recompiling, but new development should reference 
ADODB.Recordset.

There are four different cursor types defined in ADO: 

Dynamic cursor     Allows you to view additions, changes, 
and deletions by other users; allows all types of movement 
through the Recordset that doesn't rely on bookmarks; and 
allows bookmarks if the provider supports them.

Keyset cursor     Behaves like a dynamic cursor, except 
that it prevents you from seeing records that other users 
add, and prevents access to records that other users 
delete. Data changes by other users will still be visible. 
It always supports bookmarks and therefore allows all types 
of movement through the Recordset.

Static cursor     Provides a static copy of a set of 
records for you to use to find data or generate reports; 
always allows bookmarks and therefore allows all types of 
movement through the Recordset. Additions, changes, or 
deletions by other users will not be visible. This is the 
only type of cursor allowed when you open a client-side 
Recordset object.

Forward-only cursor     Allows you to only scroll forward 
through the Recordset. Additions, changes, or deletions by 
other users will not be visible. This improves performance 
in situations where you need to make only a single pass 
through a Recordset.