How to Fix Access Expressions and Missing AcroPDF.dll References
Question details
Built-in expressions in Microsoft Access fail to execute due to a missing or broken Adobe Acrobat dynamic link library reference.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Running or compiling a database that includes references to Adobe Acrobat integrations, specifically AcroPDF.dll version 1.0.
- Observed behavior
- Access displays an error message about a missing or broken reference to AcroPDF.dll, causing standard functions and expressions like DATE to break and fail to compile.
Determine whether your specific Access database actually needs Adobe Acrobat features (such as embedding or viewing PDFs on forms). If no PDF features are actively used, simply unchecking the broken reference is the fastest solution.
Clear the Missing Reference in the VBA Editor
Remove the broken AcroPDF.dll reference to allow native Access expressions to compile and run normally.
When a database is moved from a computer that had Adobe Acrobat installed to one that does not, the VBA project retains a 'broken' reference. This breaks the entire compilation process, which is why built-in expressions stop working.
With your Access database open, press ALT + F11 on your keyboard to launch the Visual Basic for Applications (VBA) editor.
In the top menu bar of the VBA editor, click on 'Tools' and select 'References' from the drop-down menu.
Scroll through the list of Available References and look for an item clearly marked as 'MISSING: AcroPDF.dll' or 'MISSING: Adobe Acrobat'. Uncheck the box next to it.
Click 'OK' to close the References dialog. Then, go to 'Debug' > 'Compile [Your Database Name]' to ensure there are no remaining errors, and save your work.

Repair or Reinstall Adobe Software
If your database relies heavily on PDF integration, you must restore the missing AcroPDF.dll file by reinstalling Acrobat.
Add the Database Folder to Trusted Locations
Add your working folder to the Access Trust Center to prevent security settings from blocking active content and library references.
Discover WPS Office for Seamless Document Management
While Microsoft Access handles complex relational databases, WPS Office is the ideal lightweight alternative for your daily word processing, spreadsheet, and presentation tasks. It features a built-in, native PDF editor, eliminating the need for external Adobe plugins that frequently cause broken DLL references and macro errors.
- 1. Download and Install: Visit the official WPS website to download the free office suite.
- 2. Open Your Office Files: Launch WPS Office and open any Word, Excel, or PowerPoint document with complete format compatibility.
- 3. Edit PDFs Natively: Use the dedicated WPS PDF tool to view, edit, and convert PDFs directly, without configuring tricky third-party DLL references.

Frequently Asked Questions
Why does a broken PDF reference break native Access expressions?
When Access loads a database with a broken VBA reference, the entire VBA project fails to compile. This compilation failure prevents Access from resolving and executing standard built-in functions, causing expressions like DATE or TRIM to result in errors.
What is AcroPDF.dll used for in Microsoft Access?
AcroPDF.dll is an ActiveX control library installed by Adobe Acrobat. Developers use it to embed PDF viewing and manipulation capabilities directly inside Access forms and reports.
Can I fix the missing reference by manually copying the AcroPDF.dll file?
Simply copying the DLL file to your system folder often isn't enough because the file must be properly registered in the Windows Registry. Repairing or reinstalling Adobe Acrobat is the most reliable way to register the library correctly.




