How to set default Recordset type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 28 Jun 2006 19:05 GMT

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

Reply to this Message

Michel Walsh - 01 Jul 2006 13:02 GMT

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

> When I design a new Access Query into my SQL Server database, the
> Recordset
[quoted text clipped - 4 lines]
>
> Steve

Reply to this Message