Using ADO`s Record Object with URLs - Creating a Reference to ADO 2.8

(Page 3 of 6 )

Create an MS Access project, add a form in design, and add a Command button and a text box. For using ADO 2.8 you need to add a reference to the library as shown in the next picture. The details of this can be found at the link Connecting-to-Microsoft-Access-with-ADO.

This same link also shows how you arrive at the connection string for the ADO connection that you are planning to make. In the present case, we need to use the MSDAIPP provider. The next picture shows some relevant pictures of the data link file url.udl from which the connection string was extracted by opening it in a text editor. The next picture shows that you need to choose the MSDAIPP provider.

The next picture shows the data source and authentication. The file has been set up for anonymous logon. At first we will be looking at the file in a web site folder. You may also verify whether the connection is working or not by testing it.

Next: Exploring the Web Page URL with ADO >>
 

More Microsoft Access Articles
More By Jayaram Krishnaswamy

Comments On: Using ADO`s Record Object with URLs

· Yes, as this tutorial shows you can dissect the folder / file structure of your...   >>> Post your comment now!