Fix Access ActiveX PDF Control Runtime Error 438
Question details
The user needs to resolve Runtime Error 438 in Microsoft Access when assigning a PDF file path to an Adobe PDF Reader ActiveX control.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Opening or assigning a PDF file to an Adobe Acrobat ActiveX control embedded in an Access form via VBA.
- Observed behavior
- The system throws Runtime Error 438, indicating that the object does not support the property or method being called.
Ensure that a compatible version of Adobe Acrobat or Adobe Reader is properly installed and licensed on the computer running the database.
Adjust the VBA Property Name for the PDF Control
Update your VBA code to use the correct property name depending on the specific version of the Adobe ActiveX control installed.
Runtime error 438 occurs when VBA attempts to call a property that does not exist for the specified object. Different versions of the Adobe PDF Reader ActiveX control use different property names to set the source file path.
Open your Microsoft Access database and press Alt + F11 to launch the Visual Basic for Applications (VBA) Editor.
Find the line of code where you are setting the file path for the embedded PDF control (e.g., Forms!ViewPDFForm!ActiveXCtl2).
If your code uses '.Source', change it to '.src' (e.g., Forms!ViewPDFForm!ActiveXCtl2.src = filepath). Conversely, if it uses '.src', try changing it to '.Source'.
Go to Debug > Compile Database in the VBA menu. Save your changes, switch back to Access, and test the form to confirm the error is resolved.

Re-add and Register the ActiveX Control
Verify that the Adobe ActiveX control is correctly registered and added through the Form Design tools.
Try WPS Office for Your Document and PDF Needs
While Microsoft Access requires complex VBA troubleshooting for PDFs, WPS Office provides a seamless, built-in PDF reader and editor alongside a powerful suite for Word, Excel, and PowerPoint files. It's a lightweight, free alternative that eliminates ActiveX compatibility issues.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
- 2. Install the Software: Run the installer and follow the simple on-screen instructions to complete the setup.
- 3. Manage Documents and PDFs: Open your existing Microsoft Office files and PDFs directly in WPS Office without worrying about complex plugin errors.

Frequently Asked Questions
Why does this Access database work on one computer but throw Error 438 on another?
The required Adobe ActiveX control must be installed, registered, and licensed on every single computer that runs the database. Different computers might have different versions of Adobe Reader installed, leading to property mismatches (such as requiring .src instead of .Source).
How can I check if the Adobe ActiveX control is available in Access?
Open a form in Design View, click 'Insert ActiveX Control' in the Form Design ribbon, and scroll through the list to look for 'Adobe PDF Reader'. If it is missing, you need to install or repair your Adobe Reader software.
Can I view PDFs in Access without using ActiveX controls?
Yes. While ActiveX controls provide an embedded viewing experience directly on the form, you can alternatively use VBA's Application.FollowHyperlink method to simply open the PDF file in the user's default external PDF viewer, which completely avoids Error 438.




