Others

How to Fix ActiveX Error 429 ADODB.Recordset in Microsoft Access

Camila MilosovichCamila Milosovich Oct 28, 2026 870 views

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.

How to Fix ActiveX Error 429 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.
Before you start

Ensure you have administrative privileges on the affected Windows computer, as modifying VBA references or repairing Microsoft Office installations requires system-level permissions.

Solution 1Recommended

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.

1
Open Visual Basic Editor

Open your Microsoft Access database and press ALT + F11 to launch the Visual Basic Editor.

2
Access the References Menu

In the top toolbar, click on 'Tools' and select 'References' from the dropdown menu.

3
Locate the ADO Library

Scroll down the list of available references and look for 'Microsoft ActiveX Data Objects [version] Library' (e.g., version 2.8 or 6.1).

4
Enable and Match Versions

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.

5
Save and Compile

Click 'OK' to save your changes. Go to 'Debug' > 'Compile' to ensure there are no remaining code errors, then restart Access.

Compare and Enable ADO References in the VBA Editor
Verification Step: If you are unsure which version to use, open the working computer's database, navigate to Tools > References, and write down the exact version checked in the list.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and click the free download button.
  2. 2. Install the Software: Run the downloaded file and follow the straightforward on-screen instructions.
  3. 3. Open Your Files: Launch WPS Office to immediately begin opening and editing your existing Office files without complicated configurations.
Seamlessly compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight installation that avoids complex ActiveX registry and dependency errors.All-in-one interface allowing you to open documents, spreadsheets, and PDFs in a single window.Free to download and use with a highly familiar user interface.
microsoft office alternative - wps office

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.