Ms access error 429 activex component

ms access error 429 activex component

Microsoft Access 2007 和2010:“運行時錯誤'429':ActiveX 組件無法創建對象” (Microsoft Access 2007 and 2010: "Run-Time Error '429': ActiveX component can't create. Selecting the Database drop down when importing from a SQL Server database using the Import utility causes an Error 429 - Active X Component can. the error "Run Time Error 429 ActiveX component can't create object or populate a recordset with the values and then insert it in a Access 2007.

This article would provide you possible fixes for Runtime error 429 activex component can’t create object. You will also come to know various reasons why the problem occurs so that by the next time, you will be prepare enough.

Know about runtime error 429 activex component can’t create object

To understand “runtime error 429 activex component can’t create object”, firstly you have to know what ActiveX components are.

ActiveX refers to be a software framework from Microsoft (MSFC) whose tasks is to make applications (even of different programming language) share functionality and data with one another over web browsers. This add-on also makes the browsing enjoying by allowing animation. As well as, it conducts the task of installing security updates at Windows Update.

The Error 429 could be a consequence of software attempting to access any corrupted files. This could be corrupted registry, deleted OS files, incomplete installation of software or corrupted system files. So, a couple more things have to be done besides the update to ensure the integrity of the system that we are going to discuss in this article.

To fix runtime error 429 activex component can’t create object caused due to PC issues, we recommend you use PC Repair Tool. This software will repair common computer errors, protect your files from files loss, malware, and hardware failure and optimize the PC for maximum performance. Here is the direct download link for this tool.

⇓ Get PC Repair Tool

How to fix runtime error 429 activex component can’t create object?

Generally, ActiveX components run 429 error or other runtime errors which are essentially bugs that users encounter in a specific program. In this case, you would have to find that software problematic and perform its update. This error is frequent for MS Office applications such as Excel, Word, Access or Outlook, with automated Visual Basic sequence scripts.

Also, there could be some other reasons like the program is not correctly configured, problem in Component Object Model due to which It can’t create Automation object and so on. Thus, there are various possible fixes for runtime error 429 activex component can’t create object. Check below the different methods to resolve common problems that cause this error.

Re-register the software

If a specific program is problematic, you need to configure that application correctly. For this, require re-registering the software with the /regserver switch. Here is hero and the terror you can:

  • Click Windows +R to open Run window (Please note you would require admin rights with a windows admin account),
  • Enter the path of the software followed by /regserver in the text box, and then click OK.

 Re-register the specific file

 You need to check for specific file for properly configured if the ActiveX error message shows a special title with .OCX or .DLL and similar file.  Usually, re-registering the file resolves the issue. This is how you can reregister specified OCX and DLL files using Command Prompt:

  • Pres Windows + X and select Command Prompt Admin (before it, make sure no software windows are opened),
  • Now, enter ‘regsvr32 Filename.ocx’ or ‘regsvr32 Filename.dll’ in the command prompt window,
  • Then, click on return key to reregister the file.

Run System File Checker for fixing corrupted system files

SFC or System File Checker is an effective remedy for fixing corrupted files. Many system errors are due to the corrupted files and runtime error 429 activex component can’t create object r-keeper runtime error 200 be the one. So, you get the fix by running the SFC scan. Here is how you can do this via command prompt:

Open Command Prompt with Administrator,

  • Enter ‘sfc /scannow’ in it and pres Return Key,

  • SFC will then start the scanning process. It will take 20 minute or longer. After the process is complete, if SFC fixes anything, you will see the following message in the command prompt:

Windows Resource Protection found corrupt files and successfully repaired them.

  • Then, Restart your windows.

Check for Windows update

You should also check for Windows updates. Microsoft keeps a regular check system issues and provides fixes with the update. So, updating Windows with latest service might resolve the runtime error:

  • Start menu search box or Enter Windows Update in Cortana,
  • Then, select the check for updates option to open the update options,
  • Click on the Check for updates button, if there is any update available, you can download it via clicking the Download button.

Undo system changes with System Restore

System Restore will undo system changes by reverting the Windows back to the earlier date. By this, you can return to the date where the ActiveX error did not occur. It is important to know that when you provide System Restore, you will lose all software and apps installed after the restore point date. Here is the step to utilize system restore:

  • Enter System Restore using Cortana,
  • In the System Restore page, crate a restore point using the System properties window,

  • Now, click on the System Restore button, click next and select Show more recent points to open the full list of restore dates,
  • Select the appropriate restore point and press Next and Finish to confirm the restore point.
Conclusion

These are some of numerous potential fixes for runtime error 429 activex component can’t create object. Hope so, the above fixes work in your case. If you want further suggestions for fixing ActiveX error 429, please let us know. Also, feel free to ask any query if you have.

Also check, ms access error 429 activex component, how to solve runtime error ms access error 429 activex component Windows

How to fix the Runtime Code 429 Microsoft Access Error 429

Last Updated:

18/07/22 11:06 : A Windows 10 user voted that repair method 1 worked for them.


Recommended Repair Tool:


This repair tool can fix common computer problems such as blue screens, ms access error 429 activex component, crashes and freezes, missing DLL files, as well as repair malware/virus damage and more by replacing damaged and missing system files.


STEP 1:
Click Here to Downloadand install the Windows repair tool.

STEP 2:
Click on Start Scanand let it analyze your device.

STEP 3:
Click on Repair Allto fix all of the issues it detected.

DOWNLOAD Mimaki jv3 error 4 flash rom src="https://www.errorvault.com/windows-logo-square.png">

Requirements
1 Ghz CPU, 512 MB RAM, 40 GB HDD
This download offers unlimited scans of your Windows PC for free. Full system repairs start at $19.95.

Article ID: ACX07222EN


Applies To: Windows 10, Windows 8.1, Windows 7, Windows Vista, Windows XP, Windows 2000



Speed Up Tip #84

Upgrade to USB 3.0:

Upgrade your computer to USB 3.0 if you are still using the older USB 1.0 or USB 2.0 connections. You can ms access error 429 activex component a transfer speed ten times faster than in USB 2.0. On top of that, the USB 3.0 standard introduces other improvements such as improved bus utilization and better power management.

Click Here for another way to speed up your Windows PC

Microsoft Access 2007 和 2010:“運行時錯誤 '429':ActiveX 組件無法創建對象” (Microsoft Access 2007 and 2010: "Run-Time Error '429': ActiveX component can't create object")

問題描述

Microsoft Access 2007 和 2010:“運行時錯誤 '429':ActiveX 組件無法創建對象” (Microsoft Access 2007 and 2010: "Run-Time Error '429': ActiveX component can't create object")

I am trying to fix a Microsoft Access database that was imported from Access 97 format to Access 2007 format (.mdb to .accdb). The import was successful and I was able to make the database fully functional from my machine. It is also fully functional from my coworker's machine. However, when taken to another building that is part of our organization, we cannot get the database to run. We know that part of the problem is within opening a connection to the web server that holds the central database (there are several copies of this Access database that consist of the same code, but different data is input into them and uploaded to this central database). Here is the code.

Things we have tried to fix this problem: 1. Added all necessary references (Ex. Microsoft XML) 2. Editing the permissions of the file and the folders 3. Registering ActiveX Controls 4. Made sure all options that can be changed match on both working and non-working machines

This old and is not my code or design. I just have to fix it.  Any help will be appreciated. 


參考解法

方法 1:

A coworker of mine figured out the answer. Those variables are objects of MSXML4, and Windows 7 comes stock with MSXML 6.0, which is evidently not compatible with MSXML 4. 

Make sure to check install packages before anything else.

You can either install MSXML 4 or change the variables to  by:

instead of

(by hall374、hall374)

參考文件

  1. Microsoft Access 2007 and 2010: "Run-Time Error '429': ActiveX component can't create object" (CC BY-SA 3.0/4.0)

Runtime 429 ActiveX component error occurs when Access calls an open Outlook

I have VBA code in MS Ms access error 429 activex component applications which create emails. The relevant code lines are:

This code worked for the past two decades, give or take. A couple months ago, about 10 users out of more than 100 can no longer generate emails from my applications. Here is the error that they get:

Error #429: "ActiveX component can't create object."

We thought the problem might be permissions related since our IT staff were playing with UAC (User Account Control) at the time. The IT staff reverted all the UAC changes and the email generation problem persists with those 10 or so staff.

There was a Windows update about the time this problem started, so the problem may be related to how MS Access interacts with Windows and/or Outlook.

Some factors to note:

  1. If Outlook is closed the code runs without error. It is only when Outlook is already open that it fails.

  2. We tried re-building profiles, changing PCs and even changing operating systems and versions of Office. We have also tried elevating permissions under which my applications run. Sometimes one of these steps seems to fix the problem and other times it does not.

  3. Most of our staff use Windows 7 and Office 2010, but we are in the process of upgrading to Windows 10 and Office 365. Some staff with the upgrade also have the email problem. And some do not.

  4. I looked at the version and build number of Office 365 on a machine that works compared to a machine that gives the error. The build and version numbers are the same. (Version 1906. Build 11727.20244)

  5. All machines in question are 64 bit (at least, that's what I've been told)

  6. Before releasing applications to staff, I create a .accde version of the file qv-r40 system error then rename the extension to .accdr so that staff are running the file in runtime mode.

solving a ms access error 429 activex component component can't create object or return reference to this object Run Time Error 429"

r's profile photo

r

unread,
Jun 1, 2010, 4:21:36 AM6/1/10

Reply to author

Sign in to reply to author

Forward

Sign in to forward

Delete

You do not have permission to delete messages in this group

Link

Report message as abuse

Sign in to report message as abuse

Show original message

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

to


I open Access 2007, open the mydatabase.accdb database, run the below
code as a macro and it runs fine.

But, if I open a Word 2007 document, try to run this as a macro, I get
the error "Run Time Error 429 ActiveX component can't create object or
return reference to this object". on the line where I am trying to open
a handle to the database at OpenDatabase("C:\mydatabase.accdb").

I want the below part to run in a Word document so it can read the data
in the last column of every row of all the tables in a document, ms access error 429 activex component,
populate a recordset with the values and then insert it in a Access 2007
table(Table1).

Sub ReturnTableText()

Dim oTable As Table
Dim oRow As Row
Dim oRng As Range
Streamer error code 403 reason forbidden sText As String
Dim count As Integer
Dim dbMyDB As DAO.Database
Dim myRecordSet As DAO.Recordset


Set dbMyDB = OpenDatabase("C:\mydatabase.accdb") ' this line throws an
' error Run Time Error 429 ActiveX component can't create object or
' return reference to this object

Set myRecordSet = dbMyDB.OpenRecordset("Table1", dbOpenDynaset)

sText = ""
count = 0

For Each oTable In ActiveDocument.Tables

runtime error windows 7 c++ For Each oRow In oTable.Rows

If oRow.Cells.count 1 Then
Set oRng = oRow.Cells(oRow.Cells.count).Range
oRng.End = oRng.End - 1
myRecordSet.Fields(count).Value = oRng.Text & Chr(44)
MsgBox myRecordSet.Fields(count).Value
count = count + 1

End If

Next oRow

Next oTable

myRecordSet.Close
dbMyDB.Close

Ir2318 memory error Sub

I checked the documentation at
http://msdn.microsoft.com/en-us/library/aa231060%28VS.60%29.aspx
but could not solve it. The registry seems proper and the required
References are present, there is no missing reference.

Any advice would be appreciated on how to solve this error.

James A. Fortune's profile photo

James A. Fortune

unread,
Jun 1, 2010, 6:43:30 AM6/1/10

Reply to author

Sign in to reply to author

Forward

Sign in to forward

Delete

You do not have permission to delete messages in this group

Link

Report message as abuse

Sign in to report message as abuse

Show original message

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

to

In:

http://groups.google.com/group/microsoft.public.access/browse_frm/thread/80e2331aecd64658

I said:

"I vaguely recall that in earlier versions of Word, ms access error 429 activex component, I think I had to
use the Workspace object within Word VBA in order to interact with
Access data correctly."

In the same post I also said:

"I haven't used Word 2007 yet so I'll refrain from making
recommendations about the best course of action when ignorance is
present."

I'll leave it at that.

James A. Fortune
[email protected]

r's profile photo

r

unread,
Jun 1, 2010, 6:12:58 PM6/1/10

Reply to author

Sign in to reply to author

Forward

Sign in to forward

Delete

You do not have permission to delete messages in this group

Link

Report message as abuse

Sign in to report message as abuse

Show original message

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

to

>> myRecordSet.Fields(count).Value = oRng.Text& Chr(44)


>> ms access error 429 activex component MsgBox myRecordSet.Fields(count).Value
>> count = count + 1
>>
>> End If
>>
>> Next oRow
>>
>> Next oTable
>>
>> myRecordSet.Close
>> dbMyDB.Close
>>
>> End Sub
>>
>> I checked the documentation at
>> http://msdn.microsoft.com/en-us/library/aa231060%28VS.60%29.aspx
>> but could not solve it. The registry seems proper and the required
>> References are present, there is no missing reference.
>>
>> Any advice would be appreciated on how to solve this error.
>
> In:
>
> http://groups.google.com/group/microsoft.public.access/browse_frm/thread/80e2331aecd64658
>
> I said:
>
> "I vaguely recall that in earlier versions of Word, ms access error 429 activex component, I think I had to
> use the Workspace object within Word VBA in order to interact with
> Access data correctly."

Can you please explain how to do that?

I tried
Set dbMyDB = DBEngine.Workspaces(0).OpenDatabase("C:\mydatabase.accdb")

But, it did not work.


> In the same post I also said:
>
> "I haven't used Word 2007 yet so I'll refrain from making
> recommendations about rvm gzip stdin invalid compressed data-crc error best course of action when ignorance is
> present."

> I'll leave it at that.

I saved the Word 2007 document as a Word 2003 document having extension
".doc" but it still did not work.

Am I missing something?

Thanks for your reply.

> James A. Fortune
> [email protected]

James A. Fortune's profile photo

James A, ms access error 429 activex component. Fortune

unread,
Jun 3, ms access error 429 activex component, 2010, 12:15:59 AM6/3/10

Reply to author

Sign in to reply to author

Forward

Sign in to forward

Delete

You do not have permission to delete messages in this group

Link

Report message as abuse

Sign in to report message as abuse

Show original message

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

to

On Jun 1, 9:12 am, r <[email protected]> wrote:

>
> Can you please explain how to do that?
>
> I tried
> Set dbMyDB = DBEngine.Workspaces(0).OpenDatabase("C:\mydatabase.accdb")
>
> But, it did not work.
>
> > In the same post I also said:
>
> > "I haven't used Word 2007 yet so I'll refrain from making
> > recommendations about the best course of action when ignorance is
> > present."
> > I'll leave it at that.
>
> I saved the Word 2007 document as a Word 2003 document having extension
> ".doc" but it still did not work.
>
> Am I missing something?
>
> Thanks for your reply.
>
> > James A. Fortune

> > [email protected]

I don't remember the exact details and the original post is too old
for Google to bring up.

Perhaps look at the following example (VBA in Excel or Word should be
similar to each other):

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q146607&

or winapi getlasterror 183 using ADODB.

If I find an example of old Word VBA code that reads or writes to an
Access database I'll post back.

James A, ms access error 429 activex component. Fortune
[email protected]

r's profile photo

r

unread,
Jun 6, 2010, 5:29:13 AM6/6/10

Reply to author

Sign in to reply to author

Forward

Sign in to forward

Delete

You do not have permission to delete messages ms access error 429 activex component this group

Link

Report message as abuse

Sign in to report message as abuse

Show original message

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

to

Actually, don't worry I got it resolved. I had to check 'Microsoft DAO
3.6 Object Library' in Tools->References.

Thanks for your reply.

0 Comments

Leave a Comment