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

"Karl E. Peterson" <karl@xxxxxxxx> wrote in message
news:eDgLMMBjHHA.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...

Oh, I may have read that differently. I'm talking about accessing .MDBs on a
Web server directly from a client, not from ASP code on the server itself.


.

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: 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? ... housekeeping, use the same database on both client and server, yadda yadda yadda... ...
    (microsoft.public.vb.general.discussion)
  • Re: Any REAL reason to use ADO vs. DAO?
    ... UNLESS THE .MDBs ARE ON A WEB SERVER, ... What's wrong with an .mdb on a webserver using DAO? ... Post replies the group. ...
    (microsoft.public.vb.general.discussion)
Loading