Access 2016 Missing MSCal.ocx file

Question

_{Wednesday, September 11, 2019 11:48 PM}

Microsoft Access VERSION 2016

Reinstalled Entire Office suite on a new computer, and moved my database file.  Upon opening db, I get this error:  "Your database contains a missing or broken reference to the file 'MSCal.ocx' version 7.0."

I went back to the old computer and searched for the MSCal file.  I found it, but it was in a subfolder of my Sage Peachtree accounting software - i.e., nowhere near anything having to do with Microsoft!  So I don't understand how the Db was able to function on the old computer, but it did.

The Db was designed by a consultant in 2013; it is therefore likely that Access version 2010 was used in the original design.

I find plenty of places to download MSCal.ocx on the web, but they're referencing 32-bit versions for Windows Visa & Windows XP, or Windows 2010 - not my current versions.

Can Anybody help me?  Thank you in advance.

All replies (6)

_{Thursday, September 12, 2019 3:00 AM}

Copy the file to your new machine, and then in a command prompt run:

regsvr32.exe "PathToOCXFile/MSCal.ocx"

This will register the file with Windows, and it will become accessible. If it still doesn't work, right-click the file and choose Properties. It may be blocked - this happens with DLL files sometimes. If so, uncheck the box beside 'Blocked'

_{Thursday, September 12, 2019 6:04 AM}

Hi Cindy,

As far as I know, the file MSCAL.OCX is a part of ActiveX Calendar control. The calendar control is not shipped in Access 2010 and newer version of Access. So existing forms that contain a calendar control won't work any more. There is never such a 64-bit version MSCAL.OCX file for Windows 10. You could not register the ActiveX Calendar control (MSCAL.OCX) manually to resolve the issue. 

You would need to edit the design of the relevant form to remove the reference and stop the use of this calendar control.  Text boxes that are bound to DateTime fields now automatically show a calendar button next to them.

You may use other controls to replace the ActiveX Calendar control. Here is a similar thread for your reference: Mcrosoft Access going from 2007 to 2016.

Hope the information was helpful. Any updates or anything unclear, feel free to post back to let us know.

Best Regards,

Herb

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

_{Thursday, September 12, 2019 1:03 PM}

Thank you for your explanation. What would be the result of registering the .ocx from an admin/elevated command prompt. Would it not register? Or, would it register successfully, but the issue would persist?

_{Friday, September 20, 2019 6:44 AM}

Hi,

I am checking the status of this issue. Do you have any update for it?

If the replies are helpful to this question, please remember to mark them as answers. Your action would be helpful to other users who encounter the same issue and read this thread. Thanks for your understanding.

Anything unclear or any questions, feel free to post them back to let us know. I will be glad to follow up and help you.

Best Regards,

Herb

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

_{Tuesday, October 8, 2019 1:30 AM}

Hi,

This thread has been around for a long time. Please remember to mark the replies as answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. 

Thank you for understanding! If you have any questions, or updates, please feel free to let me know.

Best Regards,

Herb

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

_{Sunday, December 22, 2019 1:55 AM}

Hi,

There are four files MSCAL...., .ocx included. You can load all of them from Win 7 Access al other place in your win 7 system. You also can easily register MSCAL.OCX. BUt I had no luck in registering other MSCAl iles. On my Win 10 Home I got a message that these files are outdated and recommendation find more modern version. Without these files the form of MSCAL is not displayed.