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

Jeff Johnson <i.get@xxxxxxxxxxx> wrote:
"Karl E. Peterson" <karl@xxxxxxxx> wrote in message
news:%233aFyF3iHHA.4552@xxxxxxxxxxxxxxxxxxxxxxx

The question should be the other way around, and no there is no reason
to use DAO over ADO,

UNLESS YOU'RE USING .MDBs

UNLESS THE .MDBs ARE ON A WEB SERVER, AND YOU'RE USING VBSCRIPT

IN WHICH CASE YOU ARE INSANE!

For using an MDB rather than SQL Server, or for using ADO? I find MDBs nice to work
with, in most circumstances, because they mesh so darned well with FrontPage
(damning with feint praise, I know). Plus, I can use VBA inside the MDB for
housekeeping, use the same database on both client and server, yadda yadda yadda...
--
..NET: It's About Trust!
http://vfred.mvps.org


.

Relevant Pages

  • Re: VB6 front end to SQL Server Express 2008
    ... Server but quite a bit using mdb files. ... There's only the size-limit of 2GB on ADO/JET *.mdbs ... as well as the "attaching" of the DB-Files ... Performancewise SQLite is ca. factor 1.5-3 better than ...
    (microsoft.public.vb.database)
  • Re: Any REAL reason to use ADO vs. DAO?
    ... UNLESS THE .MDBs ARE ON A WEB SERVER, ... For using an MDB rather than SQL Server, or for using ADO? ... Web server directly from a client, not from ASP code on the server itself. ...
    (microsoft.public.vb.general.discussion)
  • Re: Any REAL reason to use ADO vs. DAO?
    ... UNLESS THE .MDBs ARE ON A WEB SERVER, ... For using an MDB rather than SQL Server, or for using ADO? ... Web server directly from a client, not from ASP code on the server itself. ...
    (microsoft.public.vb.general.discussion)
  • Re: Zugriffsgeschwindigkeiten in einem W2k3-LAN
    ... dass eine Access-MDB von einem User in seinem Home-Dir auf dem Server geöffnet wird. ... Wenn der Datensatz einmal geöffnet war, so ist der weitere Zugriff darauf kein zeitliches Problem. ... Kann man Optimierungen für MDBs einrichten, ...
    (microsoft.public.de.access)
  • Re: Any REAL reason to use ADO vs. DAO?
    ... UNLESS THE .MDBs ARE ON A WEB SERVER, ... For using an MDB rather than SQL Server, or for using ADO? ... server, yadda yadda yadda... ...
    (microsoft.public.vb.general.discussion)