ActiveX Component can't create object

[tekkyun]

I have annoying error that is present on just 1 pc on our company network. When I run the the following line of code:-
Set FrmTempRs=Ctl.Form.recordsetclone
I get this error:-
Runtime error 429
ActiveX component can't create object.

I have checked code references all all looks ok. We have even tried re-installing microsoft office on this 1 pc and still get the error.

On all other pc's the database runs fine.
Can anyone offer me any clues?

 

[bubba100]

Do you have anything additonal on the form like a Rich Text Box or Common Dialog box? If you have lost the reference it is possible to see this type of error.

 

[tekkyun]

No, nothing like that. The reference is simply to a subform recordset(clone). The code line seems to use DAO code library, because if I take that reference out using my PC I get runtime error 13 'type mismatch' on that particular line. Its wierd though that I cannot simulate the runtime error 429 that I see when using the problem pc.

 

[PHV]

How is FrmTempRs declared ?
Does the db compiles properly on that pc ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[danvlas]

You could try
regsvr32 NameOfFile.dll on the offending PC
for all references...

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[tekkyun]

FrmTemprs as declared as recordset within the offending open event sub
Dim FrmTempRs as Recordset

Unfortunately can't see whether db compiles because our IT boys have decided to re-build the pc from scratch with new image. Hopefully this will do the trick, but if it doesn't
I'll post back, if the reg search doesn't help either.
Even it does work now, it'll be frustrating not knowing what the problem is. It seems strange that all of our pc's are built with standard image and others are ok.

Thanks for the ideas guys