Open (Recordset Object) —
Opens a cursor into a data source.
A Command object name, SQL statement, table name, or stored procedure name.
A variant value holding the name of a Connection object or a string containing valid ConnectionString text.
The type of cursor you would like to create. If you attempt to create
a cursor type not supported by the underlying data source, an error
may occur. The valid values for the
lngCursorType parameter are the following:
This is the default. This parameter only allows movement forward from the current record. Otherwise this cursor type is identical to the static cursor. There is one exception to this, however. Some data providers will allow you to call the MoveFirst method to move the current record pointer back to the first record in the recordset. This is the fastest cursor type.
In a keyset cursor, you cannot see new records added by other users and you cannot access records that have been deleted by other users. You can, however, see the changes to records in your recordset made by other users. All types of movement are possible in a keyset cursor recordset.
Dynamic cursors are the most flexible (and slowest) of the four types. In a dynamic cursor, additions, changes, and deletions are all visible in your recordset. All types of movement ...