Related Topics

Missing or Broken Reference??

Missing or broken references
I am in the process of detailing procedures for migrating client databases from Access 2003 to Access 2010. While testing, I encountered 'Missing reference' errors. I was able to fix them by unchecking missing references. For instance, I have fixed a missing reference in Database A (on a shared network drive) in Access 2010 from my PC. Now, when a user opens Database A for the first time after installing Access 2010 on their PC, will they enocunter the missing reference error? I am trying to determine if it will be necessary to uncheck references at each PC


Missing or broken reference to the file OWC11.DLL
I have less the 10 people that use this database and not are in it at one time but just one person is getting this error message:

Your Microsoft Office Access database or project contains a missing or broken reference to the file" OWC11.DLL" version 1.1

she has been able to work in this last week and now this AM she is getting this message.


Reserved Error -1524 and Missing ref dao2535.tlb
A client called and said they had upgraded from Office 2007 to 2010 and to Windows 7. I only had a fews issues with forms at first. I was getting a message "Missing or broken VBE reference to the file 'dao2535.tlb" and a couple reports are giving me the Reserved error -1524 message. Another blog said to remove the reference to the dao2535, which I did. Now, when attempting to find the corruption in the one table, using an Append Query, the Conversion Error file stops with the following record. I'm not sure where to go from here. I can't find this reference in tools, now.

Conversion Errors1Object TypeObject NameError DescriptionDatabase
Missing or broken VBE reference to the file 'dao2535.tlb


error message about broken reference
I'm getting an error message which says 'your microsoft access database or project contains a missing or broken reference to file dao2535.tlb version 3.5, to ensure your database worksproperly, you must fix this reference.' If I click OK enough times I am still able to use the database but does anyone know how I can fix this?


Opening database : missing or broken reference to the file msado 15.dll version 6
I get the following error on one computer when I try to open the database:

'missing or broken reference to the file msado 15.dll version 6'.


Fixing Broken References
My app has a main FE mde which requires references set to two other FE mde files that are expected to be in a specific subfolder of the main FE path.

If the references are not initially set, or the path has changed, I have code that re-sets the references and life is good. But if I then close the app and intentionally"break" a reference by renaming a ...\subfolder\FE file, on start-up I immediately get a"...contains a missing or broken reference..." message before my check references code has achance to start.

I am using the Access 2010 runtime, so the app immediately shuts down after closing the message.

So, while a"missing" reference doesn't't seem to be an issue, I don't understand how you could ever fix a"broken" reference via start-up code if Access is goingto immediately squawk about it... Is there some way around this?


Access 2007 and Access 2010 database conversion errors
I am getting the following error message when I open a *.accdb database file in access 2007 and access 2010:

“Your MS Office Access Database contains a missing or broken reference to the file MSJETSQL.TLB version 3.0".

*To ensure that your database or project works properly, you must fix this reference.”

Opened the VBE Editor in MSAccess Menu -> References Found the reference marked missing . Removed the reference.

This did not work. I am getting following Error:

Conversion Errors1
Object Type | Object Name | Error Description
Table | MSysACEs | -3831: The current file format no longer supports user-level security. The conversion or compaction process has removed any user-level permissions.
Database | Missing or broken VBE reference to the file 'MSJETSQL.TLB'.


Creating a broken reference
I'm trying to test the functionality of some code I wrote to check for broken reference code and fix it as required. How do I create a broken reference, simply deleting the file doesn't seemto be possible; I have to close access to delete the file and upon opening access the installer fixes it.


Loaded Access 2003 in Access 2010: Error missing reference
Loaded Access2003 file, and getting this msg: "Your Microsoft Access database contains a missing or broken reference to the file 'utility mode'. You must fix this reference"

Can't figure out HOW to fix this?


Broken Reference to MSCAL.OCX
I am planning a company wide upgrade to Office 2010 and I've found one database which has the following error while trying to run the DB

" You Microsoft Access database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0 "

I am opening this DB in Access 2010. I wonder if there is a safe and quick fix to this problem? (without the need of total overhaul of the DB)...


missing or broken reference to the file ꞌMSCAL.OCXꞌ
I have a database that works perfectly with 2000, 2003 and 2007 but when I try to open it on 2010 I get the following error message.

"Your Microsoft Office Access database or project contains a missing or broken reference to the file %uA78CMSCAL.OCX%uA78C."

Thanks to Allen Brown I had entered the following into my 2007 and earlier databases. Allan's web page is saying this should work in 2010
'Copyright: Allen Browne's Database And Training, 2007.
'Author: Allen Browne. [LINK]

* Note the 'IF' statement (in the client details form) has been entered by me to allow one calendar to update two text boxes.

If possible I would like to use the same coding for my 2007 and 2010 or later versions.


Broken reference to the file 'MSOUTL.OLB' version 9.2."
I have built a database using access 2007, using the Access 2003 mdb file format. My users have Access 2007 Runtime installed. Several of my users are getting the following error message when they try to open the database.

"Your CPMS database or project contains a missing or broken reference to the file 'MSOUTL.OLB' version 9.2."

When designing this database I included code automate sending emails when reports are ready. I included a reference to Microsoft Outlook object library 11, could this be the problem? It seems weird that I would only see the message now when I am trying to install updates.

The same program, with the same references have been workingon these computers for months.


Missing Reference
I created a form that has a datepicker control on it. My database is split into a front and back end. On my computer, I have no problem. it errors out because it is missing a reference. The reference is Microsoft Windows Common Controls-2 6.0 (SP4).

I am working with Access 2010 and everyon here is on Windows 7.


Broken reference when opening 2000 file in 2010
Got a new computer from my Company with Access 2010 on it. And when I open one of my databases (Access 2000) a window opens stating "Your Microsoft Access Database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0.

The problem appears to be with one of my reports. The first column contains a date field in which I entered the following format =Format$([When],"m y",0,0)

When I open the report on the old computer (Windows XP, Access 2007), it opens without the above warning. But when I open it in the new computer (Windows 7, Access 2010), I get the warning and the report shows the first column as #error.


Users with different versions of Office - missing reference
I have an application which includes a reference to the Word object library. Some of the users have Office 10 and some have Office 11 installed.

As I am developing in Access 11, I have to correct the missing reference on their machines every time I distribute. Apparently, upgrading to Office 10 isnt an option


My PivotTable and Chart controls don't work in Access 2007
When you open a Microsoft Office Access 2003 or earlier Microsoft Access file format database in Access 2007, one of the following messages appears:
* Your Microsoft Office Access database or project contains a missing or broken reference to the file '0WC10.DLL' version 1.0.
* Your Microsoft Office Access database or project contains a missing or broken reference to the file '0WC11.DLL' version 1.0.
Access 2007 opens the database file, but any Microsoft Office PivotTable controls or Microsoft Office Chart controls that are contained on forms, reports, or data access pages do not work. In addition, Access might show the message "There is no object in this control" when you open an object that contains a PivotTable control or Chart control.


Missing Reference
How do I check on a computer that only has Runtime 2007 if a reference is missing or not?
Here is my problem. I have a 2003 db that works when I run it on a computer that has the full Access 2003 version. But when I run it (using .mde database) on a system that only has runtime 2007 i get the following error. I know the error means that I am missing a reference, but where do i check to see which reference is missing on the computer with runtime 2007?
" The expression On Timer you entered as the event property setting produced the following error: The OpenForm action was canceled.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.


Missing / broken references
I have written a database in Access 2010 in 2003 format. When I run the DB with MS Acess 2003, I get messages of missing or broken references to the files "ACEDAO.DLL" and "APSVIEWPANES.DLL". I cannot detect (through the search of files) these two files on the 2010 machine. Does anybody know where these two files are located on my hard disk


Access 2007 Runtime program
I'm not sure if this is an appropriate question for this forum but I downloaded the 'Access 2007 Runtime' program from Microsoft's Download Center onto a PC which does not have Access.

I then installed one of my Access applications but when I try to run this application I get the following error message...

Your database or project contains a missing or broken reference to the file 'utility.mda'.
*To insure that your database or project works properly, you must fix this reference.


Error message after Office 2007 install
Upgraded to Office 2007. Trying to open an access file that was created in a previous version.

A window pops up with the message “Your MS Office Access db or project contains a missing or broken reference to the file ‘dao2535.tlb version 3.5. To insure that your database or projectworks properly, you must fix this reference”.

the window reappears and after the 7th click of the OK button, the window goes away and the database opens.

How can I get rid of the error message?