We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

MSAccess Error: Class does not support Automation or does not support expected interface

The issue is that it's searching out the OLE Automation reference in C:WindowsSysWOW64stdole2.tlb

That is first-rate for 64bit customers however now not for 32bit. How might I repair this?

How do I discover if the reference is used Automation anywhere ? i'm afraid of virtually doing away with the reference then finding out it's being used someplace.

replace: underneath is where the error is triggered:

Error -->  Set Cnxn = New ADODB.Connection
         With Cnxn
           .Provider = "MSDataShape"
           .Properties("Data Provider").Value = "SQLOLEDB"
           .Properties("Data Source").Value = dbserver
           .Properties("User ID").Value = username
           .Properties("Password").Value = password
           .Properties("Initial Catalog").Value = dbname
           .CommandTimeout = 120
           .ConnectionTimeout = 120
        End With

Live Chat Icon For mobile
Up arrow icon