[AccessD] Getting a Record Count using ADO

Susan Harkins ssharkins at gmail.com
Thu Nov 15 08:11:28 CST 2007


This was a huge issue years ago when they switched the default library from 
DAO to ADO because the DAO default cursor worked correctly. Many developers 
didn't include an explicit cursor type and when they tried that in ADO, they 
got errors they didn't understand.

What I find most interesting in the internal conversion of dynamic to 
keyset -- fascinating.

Susan H.


> Hi Susan
> Brilliant - Many thanks
> I chose dbOpenStatic
>
> rs1.Open selSQL1, conn1
> becomes
> rs1.Open selSQL1, conn1, dbOpenStatic
> Have a great day




More information about the AccessD mailing list