ADO Newbie

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dont laugh! Ive only just been given Access 2000 on my desktop!!!! (Pass the
chalk :)

I am used to good old VBA in Access 97, using set db = currentdb, set rs =
db.openrecordset, etc......

How easy/hard is it to convert DAO code into ADO code?

Can someone provide me with the basics please? i.e. Opening a recordset
using ADO code.

Are there any implications in using an Access97 backend and Access 2000
frontend. (until I have completed conversion/updated my colleagues version)

Many thanks in advance.

Steve.
 
Microsoft created a great little whitepaper to help ease the transition.
It's called "Migrating from DAO to ADO" It shows you how to do the ADO
equevalent of many DAO operations. You can find it on the MS website or I
have a copy on mine, here: http://www.rogersaccesslibrary.com/knowledge.html

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
I guess I should ask exactly why you want to convert to ADO? In an
All-Access environment, DAO works better, and I don't see any compelling
reason to change. The only thing you need to do is add a reference to
Microsoft DAO 3.6 Object Model and you're good to go.

Mind you, ADO is not a bad thing to learn, but it's not necessary to switch
just because you've upgraded to Access 2000.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Ah, I see.

I thought ADO was the 'new' way of doing things. If DAO is OK I will stick
with it. (I have been using for 5+ years so I was a bit concerned about
'updating' my skills.

Phew! Back to worrying about the little niggles of conversion, like where
does error number -2147352567 come from and why????

Cheers,
Steve
 
It was, but that was about five years ago! :-) The 'new' way now is ADO.NET,
which has little in common with 'classic' ADO other than three letters in
its name, and is not supported in any version of Access.

Whoosh! Here comes the future of data access technology! Whoosh! There it
goes again - what was it? Whoosh! Doesn't matter now, here comes the next
one!
 
Huh! Isn't that something! I know it used to be. That's where I got it.
Good thing I downloaded it. It's a wonderful comparison of DAO and ADO
techniques. A little dated perhaps. The author still uses:
Dim var As New Class
instead of the now-preferred:
Dim var As Class
Set var = New Class
but it does a good job of getting the average DAO user started. I still
refer to it frequently as I'm still mostly using DAO.

Thanks for pointing out that MS no longer offers it. Maybe it's because DAO
and ADO are BOTH irrelevant from Microsoft's perspective. Still, I've
noticed that Microsoft's perspective is often quite different from their
customers'.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Whoosh! Here comes the future of data access technology! Whoosh! There
it goes again - what was it? Whoosh! Doesn't matter now, here comes
the next one!
Click to expand...

<vbg>

Tim F
 
Back
Top