Error w/ workspace object

  • Thread starter Thread starter David Howlett
  • Start date Start date
D

David Howlett

We have an Office 97 application that has been running successfully for a
long time. I just installed Office 97 and our mdb files on a brand new
computer,

When it gets to the code:

Dim ws as workspace
Set ws = workspaces(0)

I get the error message:

Runtime error '429'
ActiveX component can't create object.

I check Tools->references and there are no missing modules.
The version of Office is Access 97, SR-2
The version of Windows is
XP Professional, 5.1.2600
 
If it is Access 97 then I assume it is not a matter of adding a DAO prefix
to all of your DAO objects (eg. dim ws as DAO.workspace).

Try googling on 429 in support.microsft.com. There are many causes of that
error & lots of articles about it.

HTH,
TC
 
I think the trick with error 429, is that many of the possible causes, bear
no obvious relationship to the affects!

TC
 
Thanks for replying, TC.
Weird solution to this one.

I had a third party ActiveX control that did not install properly.
Uninstalling and re-installing that made the problem go away. Weird because
it was seemingly unrelated to workspace objects.
 
Back
Top