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

printmedia
printmedia used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I think you should re-registered the DAO 3.6 dll using the following command:

regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"

Hope it works!

Author

Commented:
That did it thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial