Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Word, PowerPoint, Outlook, and Other Office Products > which is best to use ado or dao


Reply
 
Thread Tools Display Modes
  #1  
Old 07-16-2003, 04:43 AM
adzinthepub adzinthepub is offline
Contributor
 
Join Date: Mar 2003
Location: Nuneaton, England
Posts: 471
Default which is best to use ado or dao


i'm just about to write a viusaul basic application that is the front end of a database. i've never done anything like this before. i was looking on the net and there seems to be two different ways of making these databases.

either using dao or ado. could anyone tell me which is more advanced and which is the most efficient.

thanks
Reply With Quote
  #2  
Old 07-16-2003, 05:25 AM
Mandelbrot's Avatar
Mandelbrot Mandelbrot is offline
Senior Contributor
 
Join Date: Apr 2002
Location: glbTheWorld.Europe.UK
Posts: 1,201
Default

Hi Adz,


Probably ADO would be the best, though it is a preference thing. However, ADO is the new standard and is used in various programming environments where DAO is not (correct me if I'm wrong, experts).

(Personally I prefer DAO!).


Paul.
Reply With Quote
  #3  
Old 07-16-2003, 05:38 AM
KnooKie KnooKie is offline
Senior Contributor
 
Join Date: May 2003
Location: London
Posts: 802
Default

Absolutely ADO. DAO is an old method that was superceded by RDO which was subsequently superceded again by ADO.

Should you find yourself venturing down the .NET pathway it only supports ADO so it may help for any future development if you adopt ADO now.

It is faster and simpler to code as well.
Reply With Quote
  #4  
Old 07-16-2003, 05:45 AM
adzinthepub adzinthepub is offline
Contributor
 
Join Date: Mar 2003
Location: Nuneaton, England
Posts: 471
Default

thanks
Reply With Quote
  #5  
Old 07-16-2003, 05:46 AM
adzinthepub adzinthepub is offline
Contributor
 
Join Date: Mar 2003
Location: Nuneaton, England
Posts: 471
Default

ps does anyone know any good sites where i can pick up the basics of ado programming.

cheers
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DAO to ADO (Object Tables) eleal Database and Reporting 1 05-24-2003 06:46 AM
ado vs dao jigsaw1975 Database and Reporting 2 05-16-2003 10:31 AM
ADO and DAO knowledge needed florida Database and Reporting 2 05-07-2003 01:07 PM
DAO or ADO bsams Database and Reporting 1 04-22-2003 07:11 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->