By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,663 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,663 IT Pros & Developers. It's quick & easy.

ADO or DAO?

P: 77
Hi all,

I have to write new application in access2003 and I am new in access. I edited access application before and this is first time I have to create one.

I really don't know Which method I Should choose for my application ADO or DAO.

The application only has 7 tables and I have to make data entery form fro this application as well. Please guid me what is the best way to do this.

Is there any way I make user to use my command button for inserting and Uodating and deleteing data instead of using the keys at the form.(|< , < ,>, >|, etc)

Please Please Help me.
Oct 7 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
Hi all,

I have to write new application in access2003 and I am new in access. I edited access application before and this is first time I have to create one.

I really don't know Which method I Should choose for my application ADO or DAO.

The application only has 7 tables and I have to make data entery form fro this application as well. Please guid me what is the best way to do this.

Is there any way I make user to use my command button for inserting and Uodating and deleteing data instead of using the keys at the form.(|< , < ,>, >|, etc)

Please Please Help me.

Hey Sep410,

To make your life super simple in regards to the difference between choosing between DAO and ADO, If you're going to be working with MS Access Tables only within a MS Access Database, then by all mean use DAO, it is a great deal faster and a lot let code to deal with when trying to implement. If you're going to be using some other backend database, like MS SQL, Oracle, MySQL, then by all means use ADO, this will give you the ability to connect to external data without having to have a ODBC connector to get access to it.

as far is your second question goes, you can simply turn off the Navigation buttons at the bottom of the form. The form property for that is Record selector and navigation buttons. You may also want to turn off the dividing Line as well.

Hope that helps,

Joe P.
Nov 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.