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


"Bruce W. Roeser" <broeser@xxxxxxxxxx> wrote in message
news:%23TmXEe0jHHA.1624@xxxxxxxxxxxxxxxxxxxxxxx
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 :-)

You're doing everything right except for the ODBC driver (or perhaps
ODBCDirect). Lose it.

ODBC is not optimal for ISAM data stores, ie. mdb files. Use the appropriate
Jet driver/s directly, which are optimal for Office files.

-ralph


.

Relevant Pages

  • Re: Access mdb file
    ... I would use ODBC after creating a System DSN to the access MDB directory. ... There is a topic in the VFP help files called "How to: Set Up an ODBC Data ... > I have a small app that does some reporting from legacy dbf files. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: finding location of ODBC source in Access
    ... ODBC link in an Access DB? ... An Access MDB was backed-up before a computer was re-imaged ... Registry that was done before the computer was re-imaged. ...
    (microsoft.public.access.queries)
  • Re: localhost access to Access DB denied!
    ... Access MDB is not a viable database, you need to move to SQL Server ... mdb file, which has been defined in ODBC, I get the following message: ... Microsoft OLE DB Provider for ODBC Drivers ... permissions to use the '' object. ...
    (microsoft.public.access.security)
  • Re: Ridiculous problem : getting FM to talk to Access
    ... to the Access mdb. ... But this is a hurdle we have to overcome before we can proceed with ... FileMaker can import Access data via ODBC. ...
    (comp.databases.filemaker)
  • Re: Anything available that can read Microsoft .MDB files from Python?
    ... | I've read .MDB files using ODBC. ... MDBtools would be the right answer, ...
    (comp.lang.python)