Re: HElP Runtime error 429

You are accessing this site in a read-only mode. For full access to all member benefits, including message posting, please login or register. Registration is completely free, simple, and takes only a few seconds.

The message you are replying to and its parents are listed in the reverse order with the most recent posts first. This might not be the whole discussion thread. To read all the messages in this thread please click here.

Re: HElP Runtime error 429

dmc	28 Jul 2006 19:01
Thanks Tony, I will try this solution > >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 [quoted text clipped - 15 lines] > > Tony

Tony Toews

28 Jul 2006 16:56

>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
[quoted text clipped - 5 lines]
>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

Signature

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

27 Jul 2006 20:14

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

Quick links: