Others

Fix a Missing or Broken mso.dll Reference in Microsoft Access

Ayan MasoodAyan Masood Nov 22, 2026 868 views

Question details

Resolve an intermittent mso.dll reference error in a shared Microsoft Access database when no references appear to be missing.

Fix a Missing or Broken mso.dll Reference in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
Users open or work with a shared Access database that depends on Microsoft Office libraries.
Observed behavior
Access intermittently reports a missing or broken reference to mso.dll, although the references list does not show a missing item.
Before you start

Determine whether the database is split into a shared back end and individual front ends, and note whether the error affects one user or everyone. You will need an editable front-end database and access to its VBA project to check references and compile it.

Solution 1Recommended

Check the affected users and Access references

Use these checks to narrow the issue to a particular Office installation or a shared front-end database.

1
Identify the scope

Ask affected users to open their usual front-end copies and note who sees the error. If everyone uses the same front-end file, identify its location and whether the tables are linked to a separate back end.

2
Inspect VBA references

In an editable Access database, press Alt+F11 to open the VBA editor, then choose Tools > References. Look for entries marked MISSING, but do not remove a reference unless you know it is unused.

3
Compile the project

In the VBA editor, choose Debug > Compile to check for code or reference errors. Record any message and the affected user or front-end copy before proceeding.

Check the affected users and Access references
No missing entry?: A reference problem may still occur even when no item is marked MISSING. If only one user is affected, start with Office repair on that user's computer.
Free Microsoft Office alternative

Use WPS Office for Compatible Office Documents

WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations in a familiar interface. Its Microsoft Office format support makes it easier to move everyday files between suites. It does not repair Access references or replace an Access database application.

Work with spreadsheets alongside your database workflow.Open and edit common Microsoft Office formats, including DOCX, XLSX, and PPTX.Use familiar document, spreadsheet, and presentation tools.Move everyday Office files to a free, lightweight suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access report an mso.dll error when no reference is marked missing?

The references list may not reveal every intermittent Office library issue. Check whether the error affects one computer or multiple users, then try Office repair or test a newly built front end.

Where can I check references in Access?

Open an editable database, press Alt+F11, and select Tools > References in the VBA editor. Look for entries marked MISSING and investigate them before changing any references.

Should everyone use the same Access front-end file?

For a split database, use a separate local front-end copy for each user and link those copies to the shared back-end tables. This also helps identify whether a problem is specific to one copy.

Can I repair mso.dll by downloading it separately?

Use the Office installation's Modify or repair option instead of downloading a DLL from an unverified site. In Windows Settings, find Microsoft 365 or Office under Apps and select Modify.

Can WPS Office fix an Access mso.dll reference?

No. The reference belongs to Microsoft Office and Access, so use Access troubleshooting and Office repair. WPS Office can be used separately for compatible documents, spreadsheets, and presentations.