However, data control is not a very flexible tool because it could work only with limited kinds of data and must work strictly in the Visual Basic environment.We can use a much more powerful data control in VB known as ADO control to overcome these limitations. ADO stands for ActiveX data objects and as ADO is ActiveX-based, it could work in different platforms (different computer systems) and different programming languages. Besides, it could access many different kinds of data such as data displayed in the Internet browsers, email text and even graphics other than usual relational and non relational database information.

To be able to use ADO data control, you need to insert it into the toolbox and to do this, simply press Ctrl+T to open the components dialog box and select Microsoft ActiveX Data Control 6. After this only, you can proceed to build your ADO-based VB database applications.

The following example will illustrate how to build a relatively powerful database application using ADO data control and first of all, name the new form as frmBookTitle and change its caption to Book Tiles- ADO Application. Secondly, insert the ADO data control and name it as adoBooks and change its caption to book and next, insert the necessary labels, text boxes and command buttons. The runtime interface of this program is shown in the diagram below and it allows adding and deletion as well as updating and browsing of data.

Step2:

To be able to manage and access a database, you need to connect the ADO data control to a database file. We are going to use BIBLIO.MDB that comes with VB6 and to connect ADO to this database file , follow the steps below:
a) Click on the ADO control on the form and then open up the properties window.
b) Click on the ConnectionString property, the following dialog box will appear.

step3:

when the dialog box appear, select the Use Connection String's Option and next, click build and at the Data Link dialog box, double-Click the option labeled Microsoft Jet 3.51 OLE DB provider.

Step4:

After that, click the Next button to select the file BIBLO.MDB and you can click on Text Connection to ensure proper connection of the database file. Click OK to finish the connection.

Finally, click on the RecordSource property and set the command type to adCmd Table and Table name to Titles and now you are really to use the database file.

Step5:

Now, you need to write code for all the command buttons and after which, you can make the ADO control invisible.

For the Save button, the program codes are as follow:

For the Add button, the program codes are as follow:

For the Delete button, the program codes are as follow:

For the Cancel button, the program codes are as follow:

For the Previous (<) button, the program codes are

For the Next(>) button, the program codes are