Definition Microsoft ActiveX Data Objects (ADO) is a set of
Component Object Model objects for accessing data sources. It provides a layer between
programming languages and
OLE DB (a means of accessing data stores, whether they be
databases or otherwise, in a uniform manner), which allows a developer to write programs which access data, without knowing how the database is implemented. You must be aware of your database for connection only. No knowledge of
SQL is required to access a database when using ADO, although one can use ADO to execute arbitrary SQL commands. The disadvantage of this (i.e. using SQL directly) is that it introduces a dependency upon the type of database used.
See more at Wikipedia.org...