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

Same here. I just have a small website that I keep my bible studies on.
The reference table is maintained in a nice little Access MDB on my local
machine here with an ODBC connection set up and, yes, I use Front Page 2003
too - it's *very* nice to work with. In fact I like the entire Office 2003
line - they just work.

Then if I need to get at the database through a VB6 application I've already
got a small library of functions written for DAO that make life easy. No
.... I won't write enterprise-level applications with this but for nice
little Windows desktop applications it's pretty tough to beat the VB6/Access
combination.

-b :-)

"Karl E. Peterson" <karl@xxxxxxxx> wrote in message
news:eDgLMMBjHHA.4552@xxxxxxxxxxxxxxxxxxxxxxx
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: Links vs. ADO Connection
    ... Here are some thoughts about ADO and its usage. ... interfacing between Access and Sql Sever. ... But for mdb to mdb, ... backend lives on a server - it is not part of the server. ...
    (comp.databases.ms-access)
  • Re: Merge Agent fails to connect to mdb
    ... I have created a new Linked Server def using the UNC reference to the mdb. ... I again get the msg below in my Merge Agent when using the Linked ...
    (microsoft.public.sqlserver.replication)
  • Re: New Technoligy with Jet engine (terminal service and MDB)
    ... You've had answers from two intelligent and experienced database developers ... Yes, you can continue to use an MDB, by adding ODBC, and linking the tables. ... server back end, you are going to need to know the server, anway (there are ... and understood why sql is better. ...
    (comp.databases.ms-access)
  • Re: VBA Programming - HELP
    ... Of course, when I am working on an ADP, with ADO, using SQL Server, I have ... an MDB to do the things that are easier. ... Server DBA implementing the necessary table. ... Of course, if the back end is SQL Server or some other Server DB, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Guide for switching to .ADP from .MDB
    ... After struggling with the .adp for 2 days I have determined ... >decided to go with .mdb with linked tables. ... Performance problems with MDB front-ends to MS SQL Server are rarely a result ... generating the tables on the server, then hand-tweak the script before running ...
    (microsoft.public.access.adp.sqlserver)
Loading