{"id":540,"date":"2016-12-07T14:50:50","date_gmt":"2016-12-07T14:50:50","guid":{"rendered":"http:\/\/help.sealionshipping.co.uk\/?p=540"},"modified":"2016-12-07T14:50:50","modified_gmt":"2016-12-07T14:50:50","slug":"how-to-solve-missing-mscal-ocx-reference-in-microsoft-access-2010","status":"publish","type":"post","link":"http:\/\/gardiner.tech\/bluebook\/blog\/2016\/12\/07\/how-to-solve-missing-mscal-ocx-reference-in-microsoft-access-2010\/","title":{"rendered":"How to solve missing MSCAL.OCX reference in Microsoft Access 2010"},"content":{"rendered":"

\t\t\t\tOn opening a database that references Microsoft’s ActiveX Calendar Control file (mscal.ocx) in Microsoft Access 2010, the following error message is displayed:<\/p>\n

“Your Microsoft Access database or project contains a missing or broken reference to the file ‘MSCAL.OCX’ version 7.0”<\/p>\n

Clicking on the ‘OK’ button allows the database to open, however subsequent navigation to other forms also invokes the same error message.<\/p>\n\n\n\n\n\n\n\n\n
1<\/strong><\/a>.<\/strong><\/td>\nResolution<\/strong><\/p>\n

To temporarily resolve this problem follow the steps outlined below.
\nHowever note, that the solution specified is a work-around for the above problem. Microsoft has stated that the Calendar control feature is deprecated in Access 2010 and has suggested a number of options for replacing it. See the link referenced at the bottom of this page for more details.<\/td>\n

\u00a0\"\"<\/a><\/td>\n<\/tr>\n
2<\/strong><\/a>.<\/strong><\/td>\nGet the missing MSCAL.OCX file<\/strong><\/p>\n

Locate the missing MSCAL.OCX file from an Office 2007 installation.
\nThis file can be found in the %Program Files%\\Microsoft Office\\Office12 directory.<\/p>\n

(Within our network the file can be found at Z:\\Tools\\Office2010x64)<\/td>\n

<\/td>\n<\/tr>\n
3<\/strong><\/a>.<\/strong><\/td>\nCopy<\/strong><\/p>\n

Copy the file to the %SystemRoot%\\SysWow64 directory of the computer where the Access 2010 installation exist.<\/td>\n

<\/td>\n<\/tr>\n
4<\/strong><\/a>.<\/strong><\/td>\nRegister the calendar control tool (.OCX file)<\/strong><\/p>\n

I. Click on the Windows Start menu and select ‘Run’
\nII. In the Run command window enter: regsvr32 %SystemRoot%\\syswow64\\mscal.ocx
\nIII. Select OK to execute the command<\/td>\n

\u00a0\"\"<\/a><\/td>\n<\/tr>\n
5<\/strong><\/a>.<\/strong><\/td>\nAccept the registration confirmation message<\/strong><\/p>\n

Select OK to accept the displayed message confirming that the file was registered successfully.<\/td>\n

\u00a0\"\"<\/a><\/td>\n<\/tr>\n
6<\/strong><\/a>.<\/strong><\/td>\nTest<\/strong><\/p>\n

Restart Access 2010 so that the Calendar Control file reference can be recognised.<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Conclusion<\/strong><\/a><\/p>\n

Note from msdn.microsoft.com:
\nMicrosoft Access has included a Calendar control since it first added support for ActiveX controls, in Access 2.0. The calendar control, MSCAL.OCX, is not included with Access 2010. In addition, if you attempt to open a form that includes the control, you will receive the following error: “Your Microsoft Office Access database or project contains a missing or broken reference to the file \ua78cMSCAL.OCX\ua78c.”\t\t<\/p>\n","protected":false},"excerpt":{"rendered":"

On opening a database that references Microsoft’s ActiveX Calendar Control file (mscal.ocx) in Microsoft Access 2010, the following error message is displayed: “Your Microsoft Access database or project contains a missing or broken reference to the file ‘MSCAL.OCX’ version 7.0” Clicking on the ‘OK’ button allows the database to open, however subsequent navigation to other forms also invokes the same error message. 1. Resolution To temporarily resolve this problem follow the steps outlined below. However […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[47],"tags":[],"_links":{"self":[{"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/posts\/540"}],"collection":[{"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/comments?post=540"}],"version-history":[{"count":0,"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/posts\/540\/revisions"}],"wp:attachment":[{"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/media?parent=540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/categories?post=540"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/gardiner.tech\/bluebook\/wp-json\/wp\/v2\/tags?post=540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}