Using ADO with the SQL Native Client - Adding Library References and ActiveX Objects (Page 2 of 4 )
Create an MS Access application and create a new form in design. Since the ADO objects will be used you need to set up a reference. Open the Microsoft Visual Basic editor and click on Tools to obtain the following drop-down menu.
This opens the window References. Scroll down to get the Microsoft ActiveX data Objects 2.8 library and the scrrun.dll (Microsoft Scripting Runtime) items by checking them as shown in the next picture.
.
These references provide access to the methods and properties in these dlls. By referencing these libraries you also get the support of the invaluable intellisense. The properties and methods contained in these dlls can be seen in the Object Browser as shown for the ADO 2.8 library.
.
Now with the form showing you may add the Microsoft Web Browser control by accessing it as shown in the next picture. The web browser control will display the file that is obtained through the connection.
Drag and drop a button and the web browser control on the form, and resize the web browser control as shown. Add another button to explore the properties.
Next: Exploring the SQL Native Client >>
More Database Articles
More By Jayaram Krishnaswamy
/ 6 
