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
           .Open
        End With

Loader.
Up arrow icon