access basic 2007

[PaulB50]

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

 

[dymondjack]

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

 

[dymondjack]

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

 

[Douglas J. Steele]

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.

 

[David W. Fenton]

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.

 

[PaulB50]

Thankyou one & all

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.