<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
We have an Access 2003 form with some code and it's worked fine for about 2 years, but today we began getting an error: Run-time error '430': Class does not support Automation or does not support expected interface.<br />
<br />
When we click the debug button it highlights the following row:<br />
xlWs1.Cells.CopyFromRecord<wbr />set rsExcel1<br />
<br />
Any ideas why this is occurring now? We haven't done anything that could cause that.
</div>
</div>


Hi all.

We have an Access 2003 form with some code and it's worked fine for about 2 years, but today we began getting an error: Run-time error '430': Class does not support Automation or does not support expected interface.

When we click the debug button it highlights the following row:
xlWs1.Cells.CopyFromRecordset rsExcel1

Any ideas why this is occurring now? We haven't done anything that could cause that.

Run-time error '430' in access 2003 form vba

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.