IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► KBDesktop Data...Access & VBAAccess VBAUsing Data   Print This     
Next Random Article Next Random Tidbit || Change Topic Random From All

Random Tidbit

Part of the mo. lesson in the Nov 15 Issue of Prestwood eMag
Access Q&A Flashcard:
 A flashcard from our Access Flashcards Library
 A FAQ from our Access FAQ Page
 Tags: DAO , ADO , VBA
DAO versus ADO

Question:

My Access Application still uses DAO and I'm thinking about migrating it to ADO. Should I?


Answer:

No, especially if your accessing Access tables. It is true that ADO is more widespread but if your application is working with DAO, then there's no significant reason to switch. If you're starting a new Access Application that accesses Access tables, I would use DAO. If you're accessing a SQL server such as MS SQL or Oracle, I would use ADO.

Beside DAO and ADO, developers can also use OLE DB and ODBC.


Comments

0 Comments.
Share a thought or comment...
 
Write a Comment...
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P195A1
Enter key:
FAQ Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile

 KB Article #101453 Counter
8984
Since 10/30/2008
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]