How to Fix ActiveX Error 429 ADODB.Recordset in Microsoft Access
Question details
Users encounter Error 429 (ActiveX component cannot create object) when running VBA code that attempts to execute CreateObject("ADODB.Recordset") in Microsoft Access.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Executing database commands or navigating via the Access Switchboard Manager, which triggers ADODB.Recordset generation on a specific computer.
- Observed behavior
- The VBA code fails to run, throwing Error 429, despite functioning perfectly on other computers with the same database file.
Ensure you have administrative privileges on the affected Windows computer, as modifying VBA references or repairing Microsoft Office installations requires system-level permissions.
Compare and Enable ADO References in the VBA Editor
Fix missing or mismatched ActiveX Data Objects (ADO) references between the working and failing computers.
Creating an ADODB.Recordset requires an active reference to the Microsoft ActiveX Data Objects library. If this library is unchecked or a different version is selected, Access cannot create the object.
Open your Microsoft Access database and press ALT + F11 to launch the Visual Basic Editor.
In the top toolbar, click on 'Tools' and select 'References' from the dropdown menu.
Scroll down the list of available references and look for 'Microsoft ActiveX Data Objects [version] Library' (e.g., version 2.8 or 6.1).
Check the box next to the library to enable it. Ensure the selected version exactly matches the version enabled on the computer where the database works properly.
Click 'OK' to save your changes. Go to 'Debug' > 'Compile' to ensure there are no remaining code errors, then restart Access.

Repair Your Microsoft Office Installation
Use the Windows built-in repair tool to fix a damaged Access or ADO installation if the references are already correct.
Experience Lightweight Productivity with WPS Office
While Microsoft Access is a specialized database tool, frequent ActiveX errors can disrupt your workflow. For your core productivity needs—document editing, spreadsheets, and presentations—WPS Office offers a highly compatible, free, and lightweight alternative to Microsoft Office.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install the Software: Run the downloaded file and follow the straightforward on-screen instructions.
- 3. Open Your Files: Launch WPS Office to immediately begin opening and editing your existing Office files without complicated configurations.

Frequently Asked Questions
Why do I get Error 429 on only one computer?
Error 429 is a machine-specific error. It typically occurs because the affected computer has a missing or unregistered Microsoft ActiveX Data Objects (ADO) library in its system registry, or its Office installation is corrupted, even if the Access file itself is perfectly fine.
Does this error affect code generated by the Access Switchboard Manager?
Yes. The Access Switchboard Manager automatically generates VBA code that uses ADO (specifically CreateObject("ADODB.Recordset")) to navigate through records. If the ADO library is missing, clicking buttons on the Switchboard will trigger Error 429.
Which version of the Microsoft ActiveX Data Objects Library should I select?
You should select the exact version that is enabled on the computer where the database works correctly. Generally, version 2.8 or 6.1 is widely supported on modern Windows operating systems.
Can a Windows update cause ActiveX Error 429?
Yes, occasionally a Windows or Microsoft Office update may unregister certain DLL files or alter ActiveX permissions. Running an Office Repair usually restores the proper registry keys and fixes the error.




