Re(8): MDAC Posted on 3/16/2004 at 03:25:39 PM by KevinWilson
Instead of using EARLY BINDING by referencing the "Microsoft ActiveX Data Objects" library, then creating an instance of the Connection class... try leaving the reference to the ADO library out and use LATE BINDING. Use the "CreateObject" function to create an instance of the Connection class on the fly:
Dim cnValidate As Object
Set cnValidate = CreateObject("ADODB.Connection", vbNullString)
.Provider = strProvider
.ConnectionString = strDBLocation
Make sure you use error checking to make sure that you actually got a valid reference to a Connection object when you called "Set cnValidate = CreateObject(..)".