10 Year old application suddenly getting runtime 429???

[Guest]

Hi,

I'm not a programmer, but more of a database person. We've got this
application that users all over the office have been using for almost 10
years now. Suddenly one of the client machines is getting runtime 429
ActiveX can't create object. Nothing has been changed, so I don't get why
this is suddenly an issue.

I've seen this error before, and still to this day don't know how to fix
whatever it is that it's complaining about. This app worked fine on the
computer on Friday, now suddenly it's complaining about something????

This is access XP on a pentium III machine with 256mb of RAM

 

[Guest]

I don't have the application available to me right now to check what 429
Compare the references that are active on the new machine v's the others in
you office - I think that should sort that out for you.
If not, sorry.

 

[Douglas J. Steele]

Your References collection could be messed up.

References problems can be caused by differences in either the location or
file version of certain files between the machine where the application was
developed, and where it's being run (or the file missing completely from the
target machine). Such differences are common when new software is installed.

Is it an MDB or an MDE?

If it's an MDB, open the VB Editor and select Tools | References from the
menu bar. Examine all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile, available on the Debug
menu when you're in the VB Editor), go back in and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

 

[Graham Mandeno]

Hi Penny

You've had Access XP for 10 years???

There are many things that can cause this error. Do you know what Access is
trying to do when the error occurs?

Most likely it is either:

1) An ActiveX control (OCX) that either doesn't exist or is not properly
registered on the computer in question.

2) Another application (e.g. Word) which you are communicating with by
automation which is not properly registered.

 

[Guest]

It's an MDB.

I looked at all the checked references, non of them are missing.

I was successfully able to uncheck some of the references, however, when I
go back into the dialog, some of the references I unchecked are no longer in
the list.

Microsoft DAO 3.6 Object Library, and Microsoft office web components 11.0
are gone. Question is how do I get them back?

 

[Douglas J. Steele]

You sure you scrolled to the right place in the list?

DAO 3.6 should definitely be there. If it's truly gone, try reregistering
dao360.dll (should be in C:\Program Files\Common Files\Microsoft Shared\DAO)
using regsvr32.exe.

Not sure what it is you need to reregister for the web components: hopefully
someone else will be able to chime in with the file name.

 

[aaron.kempf]

no such thing as a pure database person anymore; i would reccomend
learning VB and SQL; and then when you're ready.. learn MDX.. it is a
zillion times better than silly MDB files.

for your MDB?

you should try to compile it and tell us what it chokes on.

obviously it's a broken reference or somehting; but if you uncheck DAO
and DAO is needed; that's not going to do you much good.

So.. try to compile it; it's like the middle menu item; 'compile all
modules' and then tell us what it is choking on

 

[Guest]

I was successfully able to re-register DAO 360 and when I re-registered it,
sure enough it showed up in the list. I clicked it.

Obviously I need to re-register the Microsoft Office Web components 11.0,
but don't know the right DLL.

I tried recompiling the module(s) and got "invalid object user class". As a
last ditch effort I just unintalled Office XP and reinstalled it, and now the
app works fine.

That doesn't always solve the problem though.

 

[dbahooker]

OWC 11 has to do with Office 2003 not Office XP.

-aaron

 

[Bob M via AccessMonster.com]

Some of my functions such as Left, Right, etc. quit on me and I unchecked the
same ones you did and they dissappeared like yours. The functions quit on
two different computers. I'm a conspiarcy theorist and believe that MS has
given us a present with one of their security patches. Wouldn't be the first
time.

It's an MDB.

I looked at all the checked references, non of them are missing.

I was successfully able to uncheck some of the references, however, when I
go back into the dialog, some of the references I unchecked are no longer in
the list.

Microsoft DAO 3.6 Object Library, and Microsoft office web components 11.0
are gone. Question is how do I get them back?

Your References collection could be messed up.

[quoted text clipped - 34 lines]

 

[Tony Toews]

Obviously I need to re-register the Microsoft Office Web components 11.0,
but don't know the right DLL.

Chances are you don't need it. If you uncheck that reference does
your app still compile? If it does then it very likely isn't being
used anywhere.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Some of my functions such as Left, Right, etc. quit on me and I unchecked the
same ones you did and they dissappeared like yours. The functions quit on
two different computers. I'm a conspiarcy theorist and believe that MS has
given us a present with one of their security patches. Wouldn't be the first
time.

It's an MDB.

I looked at all the checked references, non of them are missing.

I was successfully able to uncheck some of the references, however, when I
go back into the dialog, some of the references I unchecked are no longer in
the list.

Microsoft DAO 3.6 Object Library, and Microsoft office web components 11.0
are gone. Question is how do I get them back?

Your References collection could be messed up.

[quoted text clipped - 34 lines]

This is access XP on a pentium III machine with 256mb of RAM