Re: Oracle and VB - How Do I....

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Ralph (msnews.20.nt_consulting32_at_spamgourmet.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 09:32:47 -0600

"Dave" <Nobody@Nowhere.Com> wrote in message
news:urInah8$EHA.3708@TK2MSFTNGP14.phx.gbl...
> Ralph
>
> Thanks for the quick reply, I've had a look around with Google, lots of
> listings but NONE of them said what needs to be referenced so I've been
> mucking about with trial and error.
>
> What I have read confirms your suggestion re ADO so once I've worked out
> what to reference I'll give that a bash, can ADO and DAO co-exist or will
I
> need to re-do all the DAO stuff I already have for Access & Excel?
>
> The connections site you linked to looks very helpful
>
> Thanks again
> Dave.
>
<snipped>

You can use DAO and ADO in the same program.
With a few 'Gotchas'.
1) Make sure that you specifically scope all objects... ie, ADODB.Recordset/
DAO.Recordset, etc. VB6 often picks up the DAO as the 'default', but I have
seen it change its mind occasionally. <g>
2) Expect strange results if you have both data libs open and chewing on the
same database/resource at the same time. Remember that databases work very
hard to maintain integrity, but never provide concurrency.

I would preserve as much as of the DAO as I could as it just works better
with the Jet Engine.

As for the differences between MSAccess/Excel and Oracle - and there are a
ton of small nuances (wildcards, Date/Time formats, datatypes, ...) - but I
have never found a complete comprehensive list. (Also a problem because
features with also vary between Data Lib versions and providers) But don't
worry about them up front, just start playing and deal with them as you get
burned. <g>

-ralph

Relevant Pages

  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access 2007 and VB
    ... "unrecognized database format" ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)
  • Re: Access 2007 and VB
    ... and link to the download as a non expert some ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)
  • Re: Access 2007 and VB
    ... "unrecognized database format" ... There is a bit of confusion with ADO access to the new MSAccess ACCDB ... You could reference "DAO". ...
    (microsoft.public.vb.general.discussion)
  • Re: query mdb on network into Word. Access.exe not on workstation
    ... adodb provider for Jet did not know what to do. ... not sure that ADO uses DAO. ... >>> have ADO 2.8 because it was installed with the Office installation. ...
    (microsoft.public.access.externaldata)