ActiveX failure - critical problem

[David Trickett]

I have just had a major failure & had to re-install Windows, Office & just about everything else.

In the initialisation routine in my database I have:

Dim dbs As Database
Set dbs = CurrentDb

This has never given any trouble before.

Now on trying to execute the "Set dbs" line I get the run time error:

Run time error 429
ActiveX component can't create object

I have tried uninstalling & reinstalling but no use.

This is a critical problem since I am building a major project for my work & have been brought to an abrupt halt. Any help would be much appreciated.

Image of error message attached.

Thank you

 

[Jack Cowley]

Search the MS Knowledge Base (support.microsoft.com) for ActiveX component can't create object and you will find 3 or 4 articles on this subject.

hth,
Jack