Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a database created in Access 2007. When opening it in Access 2010 I get the following error:

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

Searching for this error, I found out that it is caused by the removal of the calendar control. The use of 'datapicker' is recommended instead. The problem is that AFAIK my database does not use the calendar control! I have been using the datepicker throughout.

  1. Is there any other type of object/control in that file the removal of which could be causing my problem?
  2. Is there a way to scan through the database to find out where I might be referring to that file? It is possible that a calendar control was added to a form at some point, and then deleted. Could that have left traces somewhere?
share|improve this question

2 Answers 2

up vote 2 down vote accepted

You should check any/all Forms and ensure there is no calendar object on them; I don't know of an automated way to find all instances of an object in Access forms.

To kill the reference try this:

Press ALT+F11 to open the VBA code window, and then go to Tools->References.

Un-check the references to the MS Calendar (MSCAL.OCX; probably has "MISSING" next to it), OK and save the DB.

share|improve this answer
1  
Thanks! Unchecking the box next to MS Calendar in the References window of VBA did the trick. –  Aniko Oct 7 '11 at 20:24

I had the missing MSCAL error when migrating from Access 2007 to Access 2013. Followed the instructions to go to the DBA code window and remove the check next to the MS Calendar entry and this seemed to do the trick.

share|improve this answer
    
This should be a comment, not an answer or a me too. –  AthomSfere May 9 '13 at 15:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.