Pages

Men

rh

4/04/2013

Types of cursors in DAO?

Dynamic cursor - Allows you to see additions changes and deletions by other users.


Keyset cursor - Like a dynamic cursor except that you cannot see additions by other users and it prevents access to records that other users have deleted. Data changes by other users will still be visible.

Static cursor - Provides a static copy of a recordset for you to use to find data or generate reports. 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.

No comments :

Post a Comment