Re: VBA CODE - ADODB


"David J Mark" <nntp45534-22@xxxxxxxxxxxx> wrote in message
news:y27tf.91967$lh.4359@xxxxxxxxxxxxxxxxxxxxxxxxx
>
> No. You do not want to use DAO with Access or anything else at this time.
> ADO is the way to go.

A lot of knowledgeable people will disagree with that.


>
>> DAO. One reason is that you're apparently already somewhat familiar with
>> it. A second reason is there's no advantage that ADO is going to give you
>> for an Access backend database. In fact, DAO is slightly more efficient
>> than ADO with Access databases.
>
> This is not true. It all depends on the code and queries. Granted that
> most VB/DB code is so God-awful that the database layer doesn't matter.

That's true of *anything*. One can write bad C++ code just as easily as one
can write bad VB code. Sure, if the code and queries are poorly written,
performance is going to suffer. Bad code and queries in a C++ app are also
going to hurt performance.

> If you really want to open recordsets and seek through them, etc. then ADO
> is not going to help.

Aren't you contradicting yourself?

--
Mike
Microsoft MVP Visual Basic


.

Relevant Pages

  • Desperate for help on serious TCP/IP connectivity problem
    ... MSDE either SP2 or SP3a) via TCP/IP under ADO results in queries being ... the connection to the database is made via TCP/IP ... We suspect that deep in the TCP/IP stack something is pumping messages, ...
    (microsoft.public.sqlserver)
  • Re: Knowledge Base Help Not working
    ... Database is a DAO object. ... both Access 2000 and 2002 use ADO. ... Microsoft DAO 3.6 Object Library, ... For example, to ensure that you get a DAO recordset, you'll need to ...
    (microsoft.public.access.formscoding)
  • Re: ADO and the Find method
    ... You cannot compare DAO and ADO. ... database, which has OLEDB provider. ... >>>> Opening of the whole table was not a good design anytime. ...
    (microsoft.public.vb.database.ado)
  • Re: Crosstab query error 3104
    ... Thankfully very few compile errors had to ... I have both DAO & ADO references checked but DAO is higher so it is taking ... Thanks - I inherited the original database & am gradually working through ... then perhaps you've removed the reference to ADO. ...
    (microsoft.public.access.queries)
  • Re: How do I use ADO in VC++ 6.0 to get the columns names of the t
    ... you're using DAO rather than ADO ... (ActiveX Database Objects). ... robust library for working with Jet databases. ...
    (microsoft.public.data.ado)
Loading