Snapshot or Dynaset type recordset

[James Franklin]

Hi,

With my old DAO code, I often use the OpenRecordset method to refer to the
database object. I always seem to use the type option dbOpenDynaset, even
though I am often not writing to the data, only reading it (e.g. using
FindFirst to confirm the existance of a value etc.)

Should I think about using other options like dbOpenSnapshot, or
dbOpenForwardOnly in a situation like this? I am not really sure of which
option to use when.

Thanks for any insight anyone can give,

Jim F.

 

[Guest]

James:
A ForwardOnly cursor is just that - it starts at the position indicated in
the recordset, and moves forward only. In otherwords, if the record you seek
is prior to the current record, you won't find it.
Snapshot takes... well, a snapshot of the dataset. Good for eliminating
update conflict and locking problems, but (obviously) has some other
restrictions.
If you want to restrict the recordset to readonly, you can use a Dynaset
recordset and a dbReadOnly option. Check the "OpenRecordset Method" in Help
for a good discussion about this...

TL

 

[James Franklin]

Thanks for this Todd. Does using a Snapshot or ForwardOnly type recordset
have any impact on performance? i.e. does it speed things up compared to a
Dynaset?

Jim