ADO vs. DAO

[David W. Fenton]

(I'm guessing that the thingie that we supply to ADO that lets it
read DAO really just lets ADO translate it's requests into
DAO-speak and relay them to JET).

I don't believe so. I think ADO communicates with Jet directly. But
Access communicates with ADO through an intermediate layer, the name
of which I've forgotten.

 

[Douglas J. Steele]

Thanks for all the comments. Still confused, but better informed.

Where does ADO.Net fit into this discussion, i.e., does ADO.Net have a
place in Access VBA?

Not at the present time it doesn't.

 

[(PeteCresswell)]

Per Jamie Collins:

[ADO seems] an extra layer on top of DAO

(I'm guessing that the thingie that we supply to ADO that lets it read DAO
really just lets ADO translate it's requests into DAO-speak and relay them to
JET).

ADO uses DAO?! Your guess is completely wrong. Care to guess how much
remains of your credibility on the subject of ADO vs DAO? (try zero)

Who claimed credibility? If anybody got the impression that I did, I would
correct that misapprehension. After all, I *did* say "I'm guessing...."..