How to set default Recordset type

[Steve]

When I design a new Access Query into my SQL Server database, the Recordset
type of the Access defaults to "Dynaset". How can I change the default to
"Snapshot"?


Thank You

Steve

 

[Michel Walsh]

Hi,


Nothing built in. You can always create your own class that will have a
recordset as private member (would be fine to inherit, but we can't with
VBA) and your class will expose the desire methods, but relinquish them to
its owned recordset, to the exception(s) you may want different; but that is
a LOT of work for just a default recordset type, I must add.


Hoping it may help,
Vanderghast, Access MVP