.recordcount is always doubled

[Bill Raterink]

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.

 

[David W. Fenton]

=?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.

Are you using both? If so, why in the world?

 

[David W. Fenton]

=?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.

Are you using both? If so, why in the world?

 

[Douglas J. Steele]

The References follw the MDB file, but that doesn't mean you can assume that
the references will work on his box just because they work on yours.
References are tempermental: if either you or Bill have a different version
of a particular reference, you can run into problems. For a detailed
discussion, see http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

 

[Douglas J. Steele]

The References follw the MDB file, but that doesn't mean you can assume that
the references will work on his box just because they work on yours.
References are tempermental: if either you or Bill have a different version
of a particular reference, you can run into problems. For a detailed
discussion, see http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

 

[Bill Raterink]

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.

 

[Bill Raterink]

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.

 

[David W. Fenton]

=?Utf-8?B?QmlsbCBSYXRlcmluaw==?=

As long as you
don't think having both checked is a problem, I'll leave it.

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).