CopyFromRecordset Automation Error

AlphonseG 201

ExcelSheetPopulate.txtI had been running Office 2016 MSO (16.0.12624.20278) 32-bit for several years.

I've been using the attached code in MS Access for the past 5 years without any issue.

Suddenly, getting Error 430, 'Class does not support Automation or does not support expected interface', on line 470 CopyFromRecordset.

It runs fine on other machines using various versions of Office. I have been unable to resolve the error on my dev machine.

Repaired Office, both offline and online repairs.

Uninstalled (via the uninstall troubleshooter) and reinstalled to various versions, including the very latest.

Currently running 2019 MSO (Version 2208 Build 16.0.15601.20526) 32-bit.

Unregistered/re-registered both dao360.dll and msado15.dll.

Also ran DISM and sfc.

There are no missing references.

How can I resolve this error?

Viorel 119.4K Reputation points

2025-01-20T17:10:05.43+00:00

Did you try to use ADO instead of DAO, and a simple query? (DAO seems to be deprecated).
AlphonseG 201 Reputation points

2025-01-20T17:18:41.2533333+00:00

Thanks for the reply. This is a utility that is used with many, many record sources. changing to ADO would be very time consuming and not worth it when it currently works everywhere else.
George Hepworth 0 Reputation points

2025-01-20T21:41:32.5033333+00:00

When a process fails after an extended period of success, and with not changes to the code, the first suspect is a change in the data, either datatypes or missing values most likely.

Examine the data where this process fails. It's possible that the error message is misleading.
AlphonseG 201 Reputation points

2025-01-20T21:51:15.1333333+00:00

Thanks George. Forgot to mention, I had done that also. Even tried a simple recordset that only returns 3 columns with 4 rows. Old copy of database as well as fresh copy.

1 answer