Cant create object 429

[Tim Johnson]

I had to reinstall OfficeXP and getting the following
error on a form:

Activex component can't create object429


The error occurs in a function procedure at the line:

Set cnn = CurrentProject.Connection

I have module in which I declare cnn as Public cnn as
ADODB.Connection so I do not have to declare it in each
module

I use Office 2003 and the following libraries are
selected:

Microsoft ActiveX Data Objects 2.7 Library
Microsoft ADO Ext. 2.7 for DDL and Security

Microsoft ActiveX Data Objects Recordset 2.7 Library


How can I resolve this?
I am missing any library?

Thanks

 

[Jamie]

Hi Tim,

Try unchecking all the references in you mdb, re-select them again and then
re-compile and test your mdb.

If that fails then look here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304173 and here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;310803 (They are for
2000/2002 but might point you in the right direction anyway)

Failing that you could also try the office update site at
http://office.microsoft.com/officeupdate/ - click on the "Check for updates
link" and install any that are flagged as required.

Goodluck,

Jamie
www.jamiessoftware.tk