You may experience the error message “your Microsoft Access database contains missing broken reference…” after moving your database from an earlier version of Office to a newer version. It typically occurs when the Access databases don’t get loaded properly or don’t run correctly. However, the error is quite annoying as it restricts you from accessing your database. Here’s the complete error message:
Your Microsoft Access database or project contains a missing or broken reference to the file ‘OFFOWC.DLL’ version 1.1.
* To ensure that your database or project works properly, you must fix this reference.
In this blog, I will discuss all about the above-shown error and the step-by-step workarounds to fix it. Also, I will mention the automated Access Repair Tool to solve error 29070 if it has occurred due to db reference corruption.
- Check & Remove the Missing References
- Resolving Visual Basic References in Access
- Re-Add the References
- Repair MS Office
- Use Compatible Versions
- Fully Automatic Solution to Fix MS Access Database Missing References
What Does ‘Your Microsoft Access Database Contains Missing Broken Reference’ Error Mean?
When you come across an error “missing or broken reference” in Microsoft Access, it simply means that the Access program is unable to find/load the referenced library or file that is crucial for the proper functioning of your database. However, there are a couple of reasons for the occurrence of this error. Here are the major causes:
- Missing or Moved File– The database file that MS Access is attempting to reference has been deleted, moved, or renamed.
- Corrupted Reference– If the reference gets corrupted within your database due to improper handling, then it can lead to error 29070.
- Different Version– It can happen when you’ve downgraded or upgraded your MS Office or MS Access installation and trying to access the database on another version.
- Security Settings– Microsoft Access might block a referenced file due to the security settings, especially if it is an external file.
Methods to Fix Your Microsoft Access Database or Project Contains a Missing or Broken Reference to The File Error
Apply the following solutions to troubleshoot missing or broken reference to the file offowc DLL version 10.
Method 1- Check & Remove the Missing References
The very first method that you need to try is to remove a missing reference. To do so, follow the below steps:
- Open the Access database.
- Then, press the ALT+F11 keys together to open the VBA (Visual Basic Editor).
- Go to Tools menu >> then click on References.
- Now, uncheck the box for the object library or type library that is marked as- MISSING: <referencename>.
Method 2- Resolving Visual Basic References in Access
Access loads applicable files (such as type of library, control library or object library) for every reference, as per the information that’s shown in References box. If Access can’t locate file, Access operates the following methods to situate the file:
- Access verifies to see whether referenced file is presently loaded within memory.
- If file isn’t loaded into storage, Access verifies that RefLibPaths registry key survives. If key subsists, Access appears for named value that’s similar name as reference. If there’s an equivalent, Access loads reference from path that’s named points of value.
- Access finds for the referenced file within subsequent spots, in this classification:
a. Folder of Application (location of Msaccess.exe file).
b. Present folder that you observe if you hit Open on menu of File.
c. The Winnt or Windows folder where OS files are functioning.
d. The System folder beneath Windows or Winnt folder.
e. The folders in PATH environment are inconsistent and unswervingly accessible by OS.
- If Access can’t uncover file, a reference error takes place.
Method 3- Re-Add the References
If you are well aware of which file or library is missing, then you can check and add a reference once again by navigating to the accurate location in the References dialog.
Method 4- Repair MS Office to Fix Your Microsoft Access Database Contains Missing Broken Reference
If you are suspicious that the missing or broken reference to the file offowc DLL version 10 error is related to a missing/corrupted MS Office installation component, then consider repairing the Office.
Follow the below steps to do this:
- Press Windows + R keys together to open a Run dialog box.
- Then, type appwiz.cpl >> hit Enter.
- Now, you will get the Programs and Features window opened on your screen.
- Locate Microsoft 365 and right-click on three vertical dots opposite >> click on Change/Modify.
- After this, click Yes in a UAC prompt to proceed.
- Now, you’ll see– How would you like repair your Office programs?
- Choose Quick Repair option >> Repair button.
Method 5- Use Compatible Versions
An incompatible version of referenced files with your Microsoft Access version can result in the ‘your Microsoft Access database contains missing broken reference’ error.
Therefore, if you are using a 64-bit Access version, then ensure your references are also 64-bit. This should fix Access database error 29070.
Fully Automatic Solution to Fix MS Access Database Missing References
If the above-mentioned solution does not help you to fix the MS Access database reference error then use the Compact & Repair tool. For severe database corruption, make use of a professional third-party application- Access Repair And Recovery Tool.
Making use of this software tool is the best option as it is high-end user-friendly software that repairs damaged Access databases safely and securely. This software restores forms and modules even though it is password-encrypted. Apart from that the software also recovers linked tables, modules, forms, tables, indexes, reports, queries, relations, deleted records, and macros.
Steps To Resolve Access DB Corruption & Fix Missing Or Broken Reference
Understand Reference Error Messages
There are numerous messages that communicate misplaced files or files that have a dissimilar description from the version that’s utilized in the database. In the majority of situations, you search MS Knowledge Base for articles regarding precise error notes, and you can resolve error by following the steps within the article. In a few circumstances, an addiction file is not appropriately coordinated with a primary file.
The following list portrays some of the reference error messages that you might take delivery of. On the other hand, note that the list doesn’t comprise all probable reference error notes.
“Method MethodName of Object ObjectName Failed”
Characteristically, you perhaps obtain this error if there’s an issue with the programming library, such as an unacceptable Data Access Object (DAO) dynamic-link library (DLL) file. You can hunt MS Knowledge Base for a piece that defines a variety of shapes of error messages.
“Function is un-available in Usage expression”
Though You might collect error message if difficulty with programming type library occurs, or if code doesn’t particularly call for accurate library and file is recorded at inferior priority in reference list than file that encloses same name of function –for instance, if DAO code is utilized with ActiveX Data Object (ADO) library scheduled at superior priority than DAO library. You might even get error message if form or statement comprise of an ActiveX control.
“Can’t find project or library”
Well, you may receive this error if Access can’t find the file within the reference list. Often file is observed as Missing in the dialog box of Reference. At times file exists on the development PC but not on the target system.
You may come across one of the error messages if you make use of the User-Level Security Wizard to protect a database that references libraries apart from libraries that are involved by default. Suppose, reference libraries exist in unprotected databases that aren’t automatically formulated in the new, open database.
“Run-time error 5,” “Invalid process argument or call,”
“The library that comprises of the icon isn’t referenced by existing project,” or “The library which has this symbol is referenced by the current project, so the logo is not defined”
You may receive this error messages if there’s reference to database, a type library, or object library that’s termed as Missing.
“ActiveX component cannot create object”
This error message doesn’t unavoidably mean that ActiveX control is occupied. For instance, one potential cause is DAO, which is ActiveX constituent, can’t generate objects since DAO Automation Server fails to begin. Recurrently, the cause is that DLLs providing referenced functionality for the program aren’t recorded or imperfectly registered. For further details regarding this error, click the article number beneath to view the article in MS Knowledge Base- Troubleshooting Error 429 When Automating Office Applications
Although this article is printed from the Visual Basic viewpoint, it wraps several of causes for error.
All the above-mentioned fixes whether it’s manual or automatic will surely be going to resolve your Microsoft Access database missing or broken reference error. But it’s totally up to you whether you want to go with the manual or the software solution.
Besides, if you are facing any other access database issues, feel free to ask on our social account like Twitter.