Re: Any REAL reason to use ADO vs. DAO?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

For instance, even if you specify a snapshot, it will retrieve a list of
primary keys, then start running batches of queries, of the form "Where PK
In (x, y, z)", to get the data asynchronously. It doesn't guarantee that
the snapshot is all taken at the same instant in time, only that once it
retrieves a full record, it won't refresh it.

I seemed to remember that it did things like that, but I wasn't sure, so I
didn't want to say anything. There's also the question of whether it does
that internally for Jet databases, or only for external sources. It's been
too long since I've actually worked with DAO, and I'm surprised by how much
I've forgotten and how quickly.

My own sense is that the bottleneck is usually either running a complex
query in the DB engine, or data transfer rates across a network. If it is
not one of those, the response times are fast enough that the speed
difference between DAO and ADO is not important.

That's my sense (and experience) as well, which is part of why I haven't
used DAO significantly in the last few years (the other part being that my
main project at work is an Access ADP, with no links to anything outside of
the SQL Server back-end, so DAO would be inappropriate).


Rob


.

Relevant Pages

  • Re: Run action query in back-end from front-end database
    ... whatnot in the back end database. ... The queries are housed in the back end ... The reason I have the upload tables in the back end is that it will be on ... Rick's code uses DAO, and Access 2000 doesn't have a reference set by ...
    (microsoft.public.access.externaldata)
  • Re: Error trying to use form control value in query criteria
    ... you said you had queries with form criteria. ... To execute queries or use recordset in ADO would have to be done in VBA and never via the Access UI because it's DAO by default. ... I just tested with an ADO recordset using a form control reference and as expected, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Turn off confirmations for action queries
    ... A better idea might be to use DAO to Execute the queries instead of RunSQL. ... turn off these confirmations just for this database application. ...
    (microsoft.public.access.queries)
  • OO and RDBMS design decision
    ... and another that relates the serial number to an employee ... Is it better to have one class representing one table (DAO), ... Or should I simply go for one class that does both jobs in that it queries ... On the one hand the first option seems more versatile in that I could reuse ...
    (comp.object)
  • Re: QueryDefs - DAO vs ADO
    ... I thought maybe DAO was outdated but now ... library for working with Access tables and queries. ... Dim cmd As New ADODB.Command ... ''Assign the SQL statement to the CommandText property. ...
    (microsoft.public.access.modulesdaovba)