General discussion

Locked

ActiveX error 429

By luv2bike2 ·
I am very new to ACCESS (all versions) so bear with me on this.

All the DB's were set up before I joined this company so I have no clue as
to where to go to and how to fix something.

I have a Windows XP SP 2 system, with MS Office Pro Enterprise Edition 2003.
I am using Access 2003.

The problem I am having is that I can get to one point, i will click on one
item and the form will appear but than an error message will pop up saying
that:

"Microsoft Visual Basic.
Run time error "429"
ActiveX component can't create object..
continue (which is grayed out), end, debug, help"

If I choose debug, Access will bring up MS VB form_xxxxx (code) screen. and one of the lines is hightlighted in yellow with a yellow arrow to the left of it. I have no clue as to what I should do with that. It means nothing to me. can someone explain what i need to do with that line. I have looked on other workstations and view that same exact line and it is the same, nothing is different.

I have performed all the functions that MS KB 319844 for "ActiveX component
can't create object" error message when using Access" and none of those
resolutions helped. (http://support.microsoft.com/kb/319844/en-us)

I have uninstalled Office, rebooted the workstation, reinstalled Office,
installed the MS office updates and rebooted again. Went back into the DB
and tried it again and still get the that same error message.

Any one with any other suggestions!

Thanks,

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Marshwiggle In reply to ActiveX error 429

Need more info.

The highlighted line is the next one to be executed, and and VB is telling you that it can't process that line of code for some reason.

If you can tell us what you are clicking on and what is supposed to happen at that point, plus include the highlighted line of code and a couple of lines above and below it, that would help.

Collapse -

by luv2bike2 In reply to

Ok I fix the problem.... there was 2 different DAOXXX.dll and i registered only one of them...now both are registered and i do not get the error message. Thanks for your help!!

Collapse -

by luv2bike2 In reply to ActiveX error 429

thanks for your response!

The line that is highlighted is:

Set recClone = Me.RecordsetClone()

Below are some lines before and after the line that is highlighted.

Private Sub Form_Current()

Dim recClone As Recordset
Dim intNewRecord As Integer

Set recClone = Me.RecordsetClone()

intNewRecord = IsNull(Me.ECONUMBER)

If intNewRecord Then
Me!Command17.Enabled = True
Me!Command16.Enabled = False
Me!AddNewRecord.Enabled = False
Exit Sub
End If


Once I get to Find a Document (Documentation Only) screen in Access I click on a link that says ECO Form. Once I click on that, the ECO Form appears but right after that the ActiveX error message pops up.

I can take that DB from this workstation and copy it on another workstation and it will work fine.

If you need any other information let me know.
Thanks

Collapse -

by luv2bike2 In reply to ActiveX error 429

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums