Wht have i had so many problems with ADO

I have just migrated for using Dao data access to ADO.I have had so many problems with ADO it's not funny.Could it just be a bad run or am I doing something.If anybody is using ADO full time could the help to Reassure me about its merits.
Regards T
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ADO is not mature yet.
I use both ADO and DAO in my projects so I can swith by changing single conditional directive (ADO=1 / ADO=0). I distribute only DAO version to customers for now - it is also faster on MDB database.
Éric MoreauSenior .Net ConsultantCommented:
I use ADO full time since a little more than a year now and I don't want to go back to DAO and/or RDO.

What kind of problem do you have? Do you know that, since it is not "Mature" yet, you have to download SP from time to time (www.microsoft.com/data).
I fully agree with emoreau
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

   This is the advantage ADO has with DAO
ADO is designed as an easy-to-use application level interface to Microsoft's newest and most powerful data access paradigm, OLE DB. OLE DB provides high-performance access to any data source, including relational and non-relational databases, email and file systems, text and graphics, custom business objects, and more. ADO is implemented for minimal network traffic in key Internet scenarios, and a minimal number of layers between the front-end and data source — all to provide a lightweight, high-performance interface. ADO is called using a familiar metaphor — the OLE Automation interface. And ADO uses conventions and features similar to DAO and RDO, with simplified semantics that make it easy to learn.

Megasoft Limited

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

That's not really an answer . . .


Switching from DAO to ADO can be problematic at best, and sometimes it causes so many problems you might want to just rewrite the data access portions of your app.  

What kinds of problems are you having?

Here's another URL to check out on this topic:

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.