AcitveX control problem

[Guest]

I am running 2003 on laptop and desktop both with XP at the latest updates.
I have being successfully using both machines home and at work to run and
edit the same small datbase. The desktop however has stopped updating the
database from a combo box in a form. Error message "Run time error '429'
activeX component cant create object". The combo box setting in visual basic
(debug) are identical but one works and the other doesnt. Any ideas please
???

 

[Norman Yuan]

Without knowing what exact ActiveX Control you are referring to, I can only
guess that you might run into the infamous "DLL hell" issue: the same
ActiveX Component (in an DLL or OCX file) in different version, which is
incompatible to the version you have previously. A software
installation/update could use the same ActiveX control in different version
that overwrites what you originally have. So, you have to carefully
investigate what the ActiveX Control is, what file contains it, in what
version. The most common situation is an installation/update make use an
older version that overwrite the one on your computer. Some a newer version
may also break compatibilities.

To examine what causes the problem, usually you open Access, go to VBA
Editor, click "Tools->References..." and look for any checekd reference
marked as "Missing...".

 

[Guest]

Hi Robbie,

In addition to checking for missing references, as Norman suggested, try
re-registering DAO. If that doesn't fix the problem, keep working down this
list of suggestions:

You receive a "ActiveX component can't create object" error
message when using Access
http://support.microsoft.com/?id=319844


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I am running 2003 on laptop and desktop both with XP at the latest updates.
I have being successfully using both machines home and at work to run and
edit the same small datbase. The desktop however has stopped updating the
database from a combo box in a form. Error message "Run time error '429'
activeX component cant create object". The combo box setting in visual basic
(debug) are identical but one works and the other doesnt. Any ideas please
???

 

[Guest]

Thanks tom, the first link worked a treat (re-registering [regsvr32
"C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL" ]) . My
pulse and blood pressure are back to normal!

 

[Guest]

Hi Robbie,

You're welcome. I figured that the problem was solved, after I noticed that
you marked my response as an answer on 2/5. I'm glad to hear that you are in
a relaxed euphoric state once again!


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Thanks tom, the first link worked a treat (re-registering [regsvr32
"C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL" ]) . My
pulse and blood pressure are back to normal!