But some hinderence occurs when some one wants to perform any kind of operations only on selected rows of datasheet.

Users have to select the records first and then can perform operation (whatever specified in the code).

ERP Makers will not be responsible for any kind of damage (monetary, time, personal or any other type) which may take place because of the usage of the content in the article.

DAO Object Model by default uses the Microsoft Jet database engine for data access.

MS Access), RDO was used to interface with large databases such as Oracle and SQL Server.

ADO was their replacement to interface with all types of data sources.

After connecting to a database, you can manipulate its data.

DAO is native to Access, the DAO object library is the default reference in Access 2007 and the library will be existing when you use Access (ADO object library was the default reference in Access 2000 and 2002, whereas DAO returned as the default object library with Access 2003 after being the default in Access 97 earlier).

DAO integrates well with Access databases and provides faster access.

ADO provides access to a wider variety of data sources than DAO, besides Access.

ADO has succeeded DAO and is the latest data access technology, is simpler and more flexible, and interfaces with Microsofts powerful data access technology of OLE DB.

ADOOLE DB is recommended for new projects but it might not be worthwhile to convert DAO code to ADO for existing projects.

You use the Open and Close methods to open and close a Connection object.

DAO creates a reference to the database using the database object, to connect to the data source.

A Recordset object represents a set of records in a database table, or a set of records returned from running a query.

Both DAO and ADO libraries have a Recordset object, though the methods, properties, and options of the respective object is different.

A Recordset object has a Fields collection which contains all the Field objects, where each Field object represents a column in the Recordset.

In other words, each record represents a row of data and contains many fields, and each field corresponds to a column in the database table.

Many objects, for example the Recordset object, have similar names in both DAO and ADO and it is advisable to have explicit references in your project.

This becomes a must if you have included references to both the DAO and ADO libraries in your VBA project, else the object library mentioned first in the References list will prevail, resulting in confusion in the vba code.

It was the first Objects Programming model which used the Microsoft Jet database engine, and is optimized to work Microsoft Access files (.mdb).

The objects and collections in the DAO object hierarchy are used to connect to a database, access and manipulate its data and database structure.

Microsoft Access Do While Not Eof Vba