VBA Access Recordset, Object Library

If you are going to be working with the Recordset object in VBA for Access, there are 2 options.

  1. Early binding
  2. Late binding

In the first method we add reference to the Access Object Library, before execution. It will run faster and we will have access to the VBA editor intellisense. On the other hand there is always the risk of compatibility issues arising when the program is run on a computer with a different version of the library installed. For more information about early vs late binding please see the link below:


Early Binding:

In this method you must add reference to the Microsoft ActiveX Data Object Library.

Step 1:
Reference
Step 2:
Locate the Microsoft ActiveX Data Object Library and select it:
Library
Note: The version installed on my computer might be different than the version installed on the computer you are using. This shouldn’t cause a problem.

The object can be initiated using the code below:

Dim objRecordset As ADODB.Recordset
Set objRecordset = New ADODB.Recordset


Method 2, Late Binding:

In this method we don’t need to add a reference to the object library. The Recordset object is declared as a general object and intiated as shown below:

Dim objRecordset As Object
Set objRecordset = CreateObject("adodb.recordset")

See also:

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com

One thought on “VBA Access Recordset, Object Library”

Leave a Reply

Your email address will not be published. Required fields are marked *