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

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.


"Penny" wrote:

> 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

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)


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Penny" <(E-Mail Removed)> wrote in message
news:9AE13B3C-24C3-4E92-8E0E-(E-Mail Removed)...
> 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

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.

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Penny" <(E-Mail Removed)> wrote in message
news:9AE13B3C-24C3-4E92-8E0E-(E-Mail Removed)...
> 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

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" wrote:

> 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)
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Penny" <(E-Mail Removed)> wrote in message
> news:9AE13B3C-24C3-4E92-8E0E-(E-Mail Removed)...
> > 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
>
>
>

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Penny" <(E-Mail Removed)> wrote in message
news:19AA9FD6-9DF4-48E8-9748-(E-Mail Removed)...
> 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" wrote:
>
>> 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)
>>
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Penny" <(E-Mail Removed)> wrote in message
>> news:9AE13B3C-24C3-4E92-8E0E-(E-Mail Removed)...
>> > 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
>>
>>
>>

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

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.

"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Penny" <(E-Mail Removed)> wrote in message
> news:19AA9FD6-9DF4-48E8-9748-(E-Mail Removed)...
> > 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" wrote:
> >
> >> 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)
> >>
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no private e-mails, please)
> >>
> >>
> >> "Penny" <(E-Mail Removed)> wrote in message
> >> news:9AE13B3C-24C3-4E92-8E0E-(E-Mail Removed)...
> >> > 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
> >>
> >>
> >>
>
>
>

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

-aaron

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.

Penny wrote:
>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

--
Message posted via http://www.accessmonster.com