If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Ado

'* To open in a writeable status
rs.open strSQL, currentproject.connection, adopendynamic, adlockoptimistic
'* recordcount cannot be used

'* To open as a keyset and read only
rs.open strSQL, currentproject.connection, adopenkeyset, adlockreadonly
'* recordcount can be used
Dim RC as integer
RC = rs.recordcount

'* To open as a forward only and read only
rs.open strSQL, currentproject.connection, adopenForwardOnly, adlockreadonly

'* To open as static only and read only
rs.open strSQL, currentproject.connection, adopenStatic, adlockreadonly
'* recordcount can be used
Dim RC as integer
RC = rs.recordcount
....
....
rs.close
set rs = nothing

Personally, I like ADO much better but others will have different opinons.

DAO verses ADO

For those that won't convert to ADO, I'm wondering why you prefer DAO to ADO. ADO I think is much easier to work with. I also believe that MSAccess XP defaults to ADO where the previous versions defaulted to DAO.

For those that won't convert to ADO, I'm wondering why you prefer DAO to ADO. ADO I think is much easier to work with. I also believe that MSAccess XP defaults to ADO where the previous versions defaulted to DAO.

Thanks for that, people... I realized an alternate workaround to the problem, however to answer the question:

Originally Posted by Teddy

What is your actual question? Are you unable to use DAO or do you want to convert to ADO?

I was unable to use DAO. I discovered that I could enable the plugin to get it working, however I was building an app for a large organization that doesn't enable it by default and wanted to avoid incompatibilities in my app. ( In case I was kidnapped by albino pygmies and wasn't available to help them resolve it on a new version of access that was installed, etc.)

I think I wanted to use this chunk for a dynamic reporting object but I ended up addressing it using a combination of strings associated with combo boxes, list boxes and such. Lots of code but it worked.

Thanks for the explanation, I am sure I will reference it in the near future!