Software

Ask something
Discussion Locked

ado

0 helpful
5 replies

by meet_ravikumar_s

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
in vb,ado or dao which is best?

5 replies

by danprem

Each has its own pros and cons. The DAO is much faster than ADO, whereas ADO is more flexible.If you use Acess as your backend, DAO works only uptil Acess 97 while ADO works with Access2000 & beyond.

Choosing whether to use DAO or ADO must dependon the critical requirement of the product to be developed.

As for programming easse ADO is best.

by sl-campbell

If you are connecting to a Jet or ISAM db(MDB, text file, Excel, etc.) then DAO will be fastest AND most flexible - and in most cases, and when programed right, even faster than ADO when the MDB is on the server.
If the database is a server database, then ADO will be fastest and best.
If you are not sure which direction your application may go, or there are already plans to upgrade someday to a server db, then start now with ADO, that is if the application will need to access data in an MDB OR sever database, or anything else now unknown, now or later, depending on the client.
If later it will change to use ONLY SQL server, then start with something like MSDE, which can be easily ported to SQL Server.

If you want to connect to an Access 2000 MDB you can most certainly do this with DAO 3.6, and do not need ADO.

This discussion is closed to new replies.