[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

...different between using ADO and DAO if we use...

<< Back to: Client/Server Frequently Asked Questions

Question by randy
Submitted on 10/16/2003
Related FAQ: Client/Server Frequently Asked Questions
Rating: Rate this question: Vote
what is the different between using ADO and DAO if we use the client server, if i use ms. acces as the front end and use it for the back end will i found some trouble?.


Answer by master bugoy
Submitted on 3/14/2005
Rating: Not yet rated Rate this answer: Vote
yes

 

Answer by Pranesh
Submitted on 9/19/2005
Rating: Not yet rated Rate this answer: Vote
dao disadvantages
Does not scale to web interfaces
Does not support disconnected recordsets
It doesn't scale into future projects because MS is eventually dropping all support for it
It has a very deep object model requiring a lot of "." notation which slows code down
It doesn't work well even in Access if the tables are connection tables to Sql server tables or Oracle tables.
It doesn't scale well to other databases
Ado advantages
It scales to virtually all databases that run on a MS platform
It runs quickly on large recordsets
Works great with tables in Access that are really connections to tables or views in other types of databases
It has a very shallow object model (basically Connection Command And Recordset)
Scales to future projects IE ADO.Net already exists
Supports dissconected recordsets
Supports stateless HTTP protocols

 

Answer by Aasim
Submitted on 10/19/2005
Rating: Not yet rated Rate this answer: Vote
I need same information anyone can mail me at aasim.saeed@schering.de

 

Answer by shaji
Submitted on 11/22/2005
Rating: Not yet rated Rate this answer: Vote
the data base should connect the while executive the time the problem will occur like database base name and table name

 

Answer by asdf
Submitted on 6/20/2006
Rating: Not yet rated Rate this answer: Vote
I don't know

 

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to: Client/Server Frequently Asked Questions

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]
© 2008 FAQS.ORG. All rights reserved.