Guys & girls, I have just come back to this level of programming after a
sojourn, last used access 2000. So ADO vs DAO - where is the future in terms
of future directions with Microsoft, or is there a new stream that I should
take???

regards

Personally, I use DAO for everything unless I have a specific reason not to,
and I don't believe that will change for me. I still use '03, but wouldn't
think I'd stray from my 'rule' with '07.

I have no indication where access itself is heading, but the .NET seems the
be the 'new stream' as far as languages, though I definately do cling to hope
for VBA (its all I know...)

--
Jack Leach
www.tristatemachine.com

- "A designer knows he has reached perfection not when there is nothing left
to add, but when there is nothing left to take away." - Antoine De Saint
Exupery


"PaulB50" wrote:

> Guys & girls, I have just come back to this level of programming after a
> sojourn, last used access 2000. So ADO vs DAO - where is the future in terms
> of future directions with Microsoft, or is there a new stream that I should
> take???
>
> regards

I should note to be wary of my advice... I'm certainly no guru, and .NET *I
think* would only be useful for creating standalone frontend applications...
AFAK it has no place within access itself.


--
Jack Leach
www.tristatemachine.com

- "A designer knows he has reached perfection not when there is nothing left
to add, but when there is nothing left to take away." - Antoine De Saint
Exupery


"dymondjack" wrote:

> Personally, I use DAO for everything unless I have a specific reason not to,
> and I don't believe that will change for me. I still use '03, but wouldn't
> think I'd stray from my 'rule' with '07.
>
> I have no indication where access itself is heading, but the .NET seems the
> be the 'new stream' as far as languages, though I definately do cling to hope
> for VBA (its all I know...)
>
> --
> Jack Leach
> www.tristatemachine.com
>
> - "A designer knows he has reached perfection not when there is nothing left
> to add, but when there is nothing left to take away." - Antoine De Saint
> Exupery
>
>
> "PaulB50" wrote:
>
> > Guys & girls, I have just come back to this level of programming after a
> > sojourn, last used access 2000. So ADO vs DAO - where is the future in terms
> > of future directions with Microsoft, or is there a new stream that I should
> > take???
> >
> > regards

Access 2007 has a new ACE library that's based on DAO, but enhanced for the
new functionality of Access 2007.

Whatever DAO you previously used works just fine with ACE (in fact, you
still refer to it as DAO when disambiguating).

No new development is being done on ADO, so my advice would be to stick with
DAO.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"PaulB50" <(E-Mail Removed)> wrote in message
news:92F186EB-ECD7-4F5D-BDE7-(E-Mail Removed)...
> Guys & girls, I have just come back to this level of programming after a
> sojourn, last used access 2000. So ADO vs DAO - where is the future in
> terms
> of future directions with Microsoft, or is there a new stream that I
> should
> take???
>
> regards

=?Utf-8?B?UGF1bEI1MA==?= <(E-Mail Removed)> wrote
in news:92F186EB-ECD7-4F5D-BDE7-(E-Mail Removed):

> So ADO vs DAO - where is the future in terms
> of future directions with Microsoft, or is there a new stream that
> I should take???

No. Classic ADO (the kind Access can use) has no future whatsoever.
If you're using linked tables, ADO offers you nothing of any
significance.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Thankyou one & all

"David W. Fenton" wrote:

> =?Utf-8?B?UGF1bEI1MA==?= <(E-Mail Removed)> wrote
> in news:92F186EB-ECD7-4F5D-BDE7-(E-Mail Removed):
>
> > So ADO vs DAO - where is the future in terms
> > of future directions with Microsoft, or is there a new stream that
> > I should take???
>
> No. Classic ADO (the kind Access can use) has no future whatsoever.
> If you're using linked tables, ADO offers you nothing of any
> significance.
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/
>