Run Time 429: ActiveX Cannot create object 1

[ohershey]

I have a module, built into an Access form using VBA, which calls the word application object. A typical example is

Word.Application.ScreenUpdating = False

This worked fine on Friday, when I left. Now, every time I try to compile, I get Run Time Error 429: ActiveX can't create object. I did some research, tried all of the solutions suggested by this knowledge base article:

http://support.microsoft.com/kb/319844/en-us

as well as re-copying both the dao350.dll and dao360.dll files from another system and re-registering them.

There are no references marked as missing, there is no Utility Database or Utility.mda reference listed, users (as well as admins, like myself) have access to the System32 folder, and I have tried fixing the wizard files.

Any thoughts? My whole project is sunk if I can't compile...

Thanks!

-Owen H.

 

[PHV]

You should automate your own object:
Dim myWord As Object
Set myWord = CreateObject("Word.Application")
myWord.ScreenUpdating = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ohershey]

Okay, that's got it. Now, what's REALLY driving me crazy is wondering why it worked for two weeks before blowing up.