Re: Data Base Beginner Question

Given the information available, it sounds as though Access might suit your
needs. You don't have to choose between Access and ADO. You can, if you
wish, use ADO with Access. Access supports two data-access technologies, DAO
(Microsoft Data Access Objects) and ADO (Microsoft ActiveX Data Objects).
Many long-time Access developers prefer to stick with DAO when working with
Access applications and JET (MDB) databases, but most books on programming
Access will include coverage of both DAO and ADO.

If you decide you want to learn more about Access, one of the Access MVPs,
Jeff Conrad, has an extensive list of Resources at the following URL ...

http://home.bendbroadband.com/conradsystems/accessjunkie.html

If you have a particular interest in Access and ADO, look for Access books
by Rick Dobson, published by Microsoft Press.

--
Brendan Reynolds

"Greg Wilson" <GregWilson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC06346D-7B4A-4E0A-B5B8-986A97FB1910@xxxxxxxxxxxxxxxx
>I am an experienced VBA developer with no experience with either Access or
> ADO. I need to improve in the data base area and know nothing about ADO.
> I
> currently data base using Excel or Text files only (programmatically). I
> am
> NOT a proffesional but only program to a small degree when required as a
> part
> of a skill set . I work as a technologist in a civil engineering lab and
> my
> needs relate to lab information management, data analysis (including data
> basing results), reporting etc.
>
> Hoping someone will give me advice on the best direction to take, best
> place
> to start and best sources. Perhaps Access rather than ADO is the direction
> to
> take. I obtained some ADO code that was impressive at obtaining data from
> a
> closed Excel workbook which peaked my interest in the subject. Of course,
> I
> don't understand the code.
>
> Greg


.

Relevant Pages

  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... why do you prefer DAO over ADO? ... because Microsoft does not plan to provide any future enhancements for the ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Import Text with existing schema.ini file utility
    ... but the first bit of schema.ini documentation for Jet that I ... >the Microsoft Jet Database engine and I would need to upgrade to the latest. ... >Thank you for explaining well the issues involving ADO and DAO. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Import Text with existing schema.ini file utility
    ... the Microsoft Jet Database engine and I would need to upgrade to the latest. ... Thank you for explaining well the issues involving ADO and DAO. ...
    (microsoft.public.access.modulesdaovba)
  • Re: CHANGING from DAO to RDO
    ... > For a long while, Microsoft was heavily promoting ADO, but in recent times, ... > I don't know _where_ you got the idea that ADO and RDO were the only methods ... > DAO and, for them too, DAO was simpler and easier. ... > found about performance and avoiding corruption in the Access - Jet ...
    (microsoft.public.access.modulesdaovba)
  • Re: help with code conversion
    ... Access 2002 has a reference set to ADO by default, and not one set to DAO. ... Microsoft DAO 3.6 Object Library ...
    (microsoft.public.access.conversion)