Others

How to Remove a Missing Acrobat Reference in Microsoft Access

Huma Ashraf Ch Sep 28, 2026 869 views

Question details

The user needs to remove a broken Adobe Acrobat reference (acrobat.tlb) from an Access database that prevents the References dialog from opening.

How to Remove a Missing Acrobat Reference from an Access Database

Product: Microsoft Access
Device & OS: not provided
Scenario: After uninstalling Adobe Acrobat, a Microsoft Access database retains an old reference to acrobat.tlb, which triggers an error loop and blocks access to the VBA Tools > References menu.
Observed behavior: Selecting Tools > References triggers an error message regarding acrobat.tlb. Even after removing the actual VBA code that utilized the Acrobat reference, the dialog remains completely inaccessible.

Before you start

Ensure you have full administrative rights to the database file and press ALT + F11 to verify you can at least open the Visual Basic for Applications (VBA) editor without triggering an immediate crash.

Solution 1Recommended

Identify and Remove the Reference Using the Immediate Window

Since the standard Tools > References dialog is locked by an error loop, you can bypass the interface and use VBA commands in the Immediate window to enumerate and remove the broken reference.

Microsoft Access stores object library references internally. When a referenced file like acrobat.tlb is deleted or uninstalled from the system, Access may refuse to open the visual manager. Using a standard module allows you to programmatically loop through all references to find the exact name and GUID of the missing file.

Open the VBA Editor

Launch your Microsoft Access database and press ALT + F11 on your keyboard to open the Visual Basic for Applications (VBA) Editor.

Insert a Standard Module

In the top menu, click on 'Insert' and select 'Module' to create a new blank standard module.

Add the Reference Dumping Code

Paste the following VBA procedure into the module window: Public Sub DumpReferences() Dim ref As Access.Reference Dim strFullPath As String On Error Resume Next For Each ref In Access.Application.References strFullPath = ref.FullPath If Err.Number <> 0 Then strFullPath = "[n/a]" Err.Clear End If Debug.Print ref.GUID & ": " & ref.Name & ", " & strFullPath Next ref End Sub

Run the Procedure

Press CTRL + G to open the Immediate Window at the bottom of the editor. Type 'DumpReferences' and press Enter. Review the generated output to identify the exact name (e.g., 'Acrobat') and file path of the broken reference.

Remove the Broken Reference

Now that you know the internal name of the missing reference, type the following command into the Immediate window and press Enter: Application.References.Remove Application.References("Acrobat"). Replace "Acrobat" with the exact name identified in the previous step.

Identify and Remove the Reference Using the Immediate Window

Access Restored: Once the missing reference is programmatically removed, you should be able to click Tools > References normally without triggering the acrobat.tlb error.

Free Microsoft Office alternative

Try WPS Office for Your Document and PDF Needs

While Microsoft Access manages your relational databases, WPS Office is an excellent, free alternative for handling documents, spreadsheets, presentations, and PDFs natively without relying on external Adobe Acrobat references.

Built-in PDF editor removes the need for third-party Adobe plugins or referencesHigh compatibility with Microsoft Word, Excel, and PowerPoint formatsFree, lightweight, and incredibly easy to install on multiple devicesFamiliar user interface allowing for seamless migration and zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does uninstalling Adobe Acrobat break my Access database?

Access VBA projects often set explicit references to external object libraries like acrobat.tlb to interact with PDF functions. If you uninstall Acrobat, Access still looks for the file at its original system path, causing compilation and startup errors.

How do I open the Immediate window in the VBA editor?

In the Microsoft Visual Basic for Applications (VBA) editor, you can open the Immediate window by pressing CTRL + G on your keyboard, or by selecting View > Immediate Window from the top menu bar.

Can I manually uncheck a missing reference if the dialog opens?

Yes. If you manage to open the Tools > References dialog in the VBA editor, any missing or broken library will be prefixed with the word 'MISSING:'. Simply uncheck the box next to it and click OK to resolve the error.

Office Quick Solutions