Error 430, Class does not support Automation, Windows 2000 sp4.

[Manuel Lopez]

After installing Windows 2000 sp 4, I get an error using the
CopyFromRecordset method of Excel's Range object that I never got
before:

Error 430: Class does not support Automation or does not support
expected interface.

I am using CopyFromRecordset in Microsoft Access 2002, with Excel
2002 installed, and the recordset rs is a DAO recordset:
wks.Range("A2").CopyFromRecordset rs

The error does NOT occur on Windows XP machines, whether with or
without jet sp 7 installed, only on Windows 2000 machines with
sp4. The error did NOT occur with sp3 installed.

Any help? Ideas?

 

[Rick]

Have you read the readme?

 

[Manuel Lopez]

Yes, but I didn't see anything on this issue there or in any
related sp4 files. Can you tell me what specifically you have in
mind? Thanks.

Have you read the readme?

 

[Manuel Lopez]

Here's something:
I manually replaced the dao360.dll file installed by sp4 (version
03.60.6508.2, size 561,424 bytes), with the sp3 one (version
03.60.3714.5, size 557,328 bytes). The file is located under:
"\Program Files\Common Files\Microsoft Shared\DAO\.

I made sure again that the DAO reference still pointed to this
dao360.dll, and then I rebooted. The problem disappeared (btw,
rebooting had not solved the problem before). So I think the
problem is definitely the new dao installed by Windows sp4. I'll
have to see what installing jet sp7 does (jet sp7 doesn't create
a problem in windows xp).

I'm wary of mixing and matching different versions of the jet
files together, however.



"Manuel Lopez" <[email protected]>
wrote in message After installing Windows 2000 sp 4, I get an error using the
CopyFromRecordset method of Excel's Range object that I never got
before:

Error 430: Class does not support Automation or does not support
expected interface.

I am using CopyFromRecordset in Microsoft Access 2002, with Excel
2002 installed, and the recordset rs is a DAO recordset:
wks.Range("A2").CopyFromRecordset rs

The error does NOT occur on Windows XP machines, whether with or
without jet sp 7 installed, only on Windows 2000 machines with
sp4. The error did NOT occur with sp3 installed.

Any help? Ideas?

 

[Manuel Lopez]

It turns out that jet sp 7 was automatically installed with
windows 2000 sp4.
So the bug is in the windows 2000 version of the dao360.dll file
of jet sp 7, version 3.60.6508.2. (not in the xp version).

"Manuel Lopez" <[email protected]>
wrote in message Here's something:
I manually replaced the dao360.dll file installed by sp4 (version
03.60.6508.2, size 561,424 bytes), with the sp3 one (version
03.60.3714.5, size 557,328 bytes). The file is located under:
"\Program Files\Common Files\Microsoft Shared\DAO\.

I made sure again that the DAO reference still pointed to this
dao360.dll, and then I rebooted. The problem disappeared (btw,
rebooting had not solved the problem before). So I think the
problem is definitely the new dao installed by Windows sp4. I'll
have to see what installing jet sp7 does (jet sp7 doesn't create
a problem in windows xp).

I'm wary of mixing and matching different versions of the jet
files together, however.



"Manuel Lopez" <[email protected]>
wrote in message After installing Windows 2000 sp 4, I get an error using the
CopyFromRecordset method of Excel's Range object that I never got
before:

Error 430: Class does not support Automation or does not support
expected interface.

I am using CopyFromRecordset in Microsoft Access 2002, with Excel
2002 installed, and the recordset rs is a DAO recordset:
wks.Range("A2").CopyFromRecordset rs

The error does NOT occur on Windows XP machines, whether with or
without jet sp 7 installed, only on Windows 2000 machines with
sp4. The error did NOT occur with sp3 installed.

Any help? Ideas?