.recordcount is always doubled

  • Thread starter Thread starter Bill Raterink
  • Start date Start date
Thanks Steve, I knew it was in there but I just couldn't find it. It seems I
have BOTH libraries checked, the DAO 3.6 AND the ActiveX Data Objects 2.6.
The DAO comes first in the list, if that matters. I'll put DAO. on all my
references just as a precaution.

Also, The good & the bad .mdb files are the same. I can't check the other
Bill's box as he's gone, but can I assume that the Tools/Ref settings FOLLOW
the .MDB, or are they MS OFFICE installation dependent. IOW, should I expect
his box to be the same as mine. Thanks, -Bill.
 
=?Utf-8?B?QmlsbCBSYXRlcmluaw==?=
I knew it was in there but I just couldn't find it. It seems I
have BOTH libraries checked, the DAO 3.6 AND the ActiveX Data
Objects 2.6. The DAO comes first in the list, if that matters.
I'll put DAO. on all my references just as a precaution.
Click to expand...

Are you using both? If so, why in the world?
 
=?Utf-8?B?QmlsbCBSYXRlcmluaw==?=
I knew it was in there but I just couldn't find it. It seems I
have BOTH libraries checked, the DAO 3.6 AND the ActiveX Data
Objects 2.6. The DAO comes first in the list, if that matters.
I'll put DAO. on all my references just as a precaution.
Click to expand...

Are you using both? If so, why in the world?
 
I'm not really using both, that's what I'm set up for. Most of what I do is
help other people, so I don't know which one they'll need. As long as you
don't think having both checked is a problem, I'll leave it. I just can never
remember how to get there to change them when I need to. Thanks for the help.
 
Thanks for the info Doug, I think Bill & I should always have the same level,
but you're probably right in that I shouldn't depend on it. Good to know
that the refs follow the mdb. Thanks, -Bill.
 
=?Utf-8?B?QmlsbCBSYXRlcmluaw==?=
As long as you
don't think having both checked is a problem, I'll leave it.
Click to expand...

I think it *is* a problem, unless you meticulously disambiguate all
your uses of the overlapping objects, like Recordsets:

Dim rs1 As DAO.Recordset
Dim rs2 AS ADODB.Recordset

If you don't need both, don't have both.

Indeed, you can use a lot of ADO without needing to have a
reference. Take a look at the code the Switchboard wizard generates
-- it's ADO but doesn't need a reference to work because it uses
late binding. This is good coding practice.

In an Access application with a Jet back end or using ODBC linked
tables to a server back end, your default library should be DAO.
When you need ADO, you can use late binding (you shouldn't need it
very often).
 
Back
Top