HElP Runtime error 429

[dmc]

I am running an Access 2002 database on a Windows 98 machine loaded with
OfficeXP. The machine I developed on is running Windows XP version 2002. I
have been using the DB on both machines for some time. Today I ran a windows
update to patch the 98 machine as well as a defrag, the machine has not been
updated for some time and was loaded down. Since the 98 maintenance The DB
switchboard will not come up on the 98 machine in form view at all. I get a
error 429 message reading Active X component can't create object.
The code on the On Open Event seems to be stopping here.
Set con = Application.CurrentProject.Connection
Could something have happened with the updates or the defrag. I have it
running on my machine and I tried to reload the DB and continue to get this
error. Not sure.
what I did.
I would appreciate any help
Thanks in advance

 

[Tony Toews]

I am running an Access 2002 database on a Windows 98 machine loaded with
OfficeXP. The machine I developed on is running Windows XP version 2002. I
have been using the DB on both machines for some time. Today I ran a windows
update to patch the 98 machine as well as a defrag, the machine has not been
updated for some time and was loaded down. Since the 98 maintenance The DB
switchboard will not come up on the 98 machine in form view at all. I get a
error 429 message reading Active X component can't create object.
The code on the On Open Event seems to be stopping here.
Set con = Application.CurrentProject.Connection

If this was a DAO function then you'd probably need to register the
DAO dll using regsvr32. For example regsvr32 "C:\Program Files\Common
Files\Microsoft Shared\DAO\DAO350.DLL" or DAO360.DLL

However given that it's ADO you probably need to muck a bit with MDAC.
See ACC2002: Err Msg: "ActiveX Component Can't Create Object"
http://support.microsoft.com/support/kb/articles/q304/1/73.asp

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

 

[dmc]

Thanks Tony, I will try this solution

If this was a DAO function then you'd probably need to register the
DAO dll using regsvr32. For example regsvr32 "C:\Program Files\Common
Files\Microsoft Shared\DAO\DAO350.DLL" or DAO360.DLL

However given that it's ADO you probably need to muck a bit with MDAC.
See ACC2002: Err Msg: "ActiveX Component Can't Create Object"
http://support.microsoft.com/support/kb/articles/q304/1/73.asp

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