You could also accomplish this by specifically creating a reference to the ADO version 2.0 type library and creating the object. For example: Set conn1 = CreateObject("ADODB.Connection.2.0") As Object However, it does allow you to skip referencing the ADO library from your project, and enables you to instantiate specific versions of objects. Objects instantiated with CreateObject are late-bound, which means that they are not strongly typed and command-line completion is disabled. Set conn1 = CreateObject("ADODB.Connection") As Object With the CreateObject method, the declaration and object instantiation must be two discrete steps: Dim conn1 You can use the New keyword with Dim to declare and create instances of ADO objects in one step: Dim conn As New ADODB.ConnectionĪlternatively, the Dim statement declaration and object instantiation can also be two steps: Dim conn As ADODB.Connectionįor example, if you include references to both ADO and DAO in the same project, you should include a qualifier to specify which object model to use when instantiating Recordset objects, as in the following code: Dim adoRS As ADODB.Recordset To create an automation variable and an instance of an object for that variable, you can use two methods: Dim or CreateObject. Microsoft DAO 3.5 Object Library (or later) Microsoft Access 8.0 Object Library (or later) In Microsoft Access, select or create a module from the Modules tab in the Database window. You can use ADO just as easily with Visual Basic for Applications, by using Microsoft Access, for example. Visual Basic runtime objects and procedures Verify that at least the following libraries are also selected: Select Microsoft ActiveX Data Objects x.x Library from the list. In Visual Basic, from the Project menu, select References.
To reference ADO from Microsoft Visual Basic The ADO library must be referenced by your project. This topic addresses using ADO with both Visual Basic and Visual Basic for Applications and notes any differences.
Microsoft activex data objects 2.8 library download code#
Setting up an ADO project and writing ADO code is similar whether you use Visual Basic or Visual Basic for Applications.
0 kommentar(er)
