ADO or DAO?

[Sep410]

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.

[PianoMan64]

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.