My two cents worth:
RDO is for server databases - don't bother if you only use Access. DAO is
the "old guard" for access to Jet databases. Both are relatively mature and
ADO is the "new kid on the block". If you're building new code, it's
probably worth a look. Personally, I tend to shy away from stuff this new
for large scale applications until the technology has been around for a
couple of revs in order to avoid getting hooked into the "D.O. of the Month
Case in Point:
In the VB3 days, if you wanted e-mail in your apps, you either coded the
MAPI APIs or used the MAPIMessage and MAPISession controls. Around the
release of VB4, we got "OLE Messaging", with "ActiveX Messaging" following
close on it's heels. Now we have "Collaboration Data Objects" or something.
That's a rate of about a major rev per year.
Now, any of these approaches will probably do an equally decent job of
sending a message or an attached file. For my money, I wish MS would just
settle down a bit and give me some type of messaging interface that has a
longer lifespan than my next development schedule. It's great that CDO can
now brew my morning coffee, but will it still exist at the end of the month?
The Technology of the Month Club Syndrome isn't isolated to messaging
either. How many revs per year have we had of Internet Explorer and Internet
Information Server? I'd like to see whatever's available now have something
more than a three or four month lifespan before I start writing code against
Staying on the cutting edge is fine, so long as you can keep yourself off of
the bleeding edge.
>I have been working with DAO/JET for some time now. Most of my
>database apps tend to be centered around Access as that is what most
>of my users have available, i.e., they are not using SQL Server, Oracle,
>etc. They may have Oracle but not so that a new app can be hosted
>My question is should I even consider upscaling my apps to RDO given
>this? I have read where DAO is still the preferred environment for
>JET dbs but for how long (ADO, ODBCDirect, etc.)?
>Any insight will be appreciated.