Microsoft's ActiveX Calendar Control file (mscal.ocx) is normally installed when you install Microsoft Office Professional (i.e. A version including Access) or when you install Microsoft Access. If you don't have a copy of this file you can download and install a copy here.
Hi, I was wondering if I could get some help with the following error when opening a database Access.mdb 'Your Microsoft Access database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0' It is very annoying it comes up everytime you run the database. I have changed the calendar in my database built in Access 2003 (which is working really well) so that it uses the datepicker code obtained from This still does not work. It keeps telling me the same error. I wonder if there is a way of working around this issue. Any help would be greatly appreciated.
Thank you in advance. Hi, Thank you for using Office IT Pro General Discussions forum.
The calendar control is not shipped in Access 2010 for a number of reasons. If you open a form that has mscal.ocx and you will see the following error: “Your Microsoft Office Access database or project contains a missing or broken reference to the file 'MSCAL.OCX’.” To fix this issue, you will need to remove this from your application. Here are some alternatives: 1.
Use datepicker. Here is an example on the datepicker- 2.
Use other 3rd-party calendar controls that are available on the Web. Here are a couple of community provided calendar controls: For details, you can refer to this blog: Best Regards, Sally Tang. Hi, Thank you for using Office IT Pro General Discussions forum. The calendar control is not shipped in Access 2010 for a number of reasons. If you open a form that has mscal.ocx and you will see the following error: “Your Microsoft Office Access database or project contains a missing or broken reference to the file 'MSCAL.OCX’.” To fix this issue, you will need to remove this from your application. Here are some alternatives: 1.
Use datepicker. Here is an example on the datepicker- 2. Use other 3rd-party calendar controls that are available on the Web.
Here are a couple of community provided calendar controls: For details, you can refer to this blog: Best Regards, Sally Tang. It looks like this thread may have died on the vine. But what the heck.
I'll ask anyway. Is there a reason why you can't simply install the MSCAL.OCX and include it in your references? (C: Program Files (x86) Microsoft Office Office 12 MSCAL.OCX) I have done this on my PC, and it seems to work. Yes, it's a PITA to have to install it on any/all PC's that you have your program on. But that is just what we seemingly have to endure with Access versioning. Looking in the above directory, it appears that the MSCAL also requires a few related files: MSCAL.CNT, MSCAL.DEP, MSCAL.HLP Perhaps there is an install program that does the whole thing? I am off to research that now.
Apparently Microsoft used to have this available in the download center, but has since removed it.:( It also appears that even if you have the OCX, it has to be added to the Windows Registry before you can use it. I'm not sure I'm brave enough to start messing around. I guess I'm off to the land of application re-design.
Thanks MoneySoft.:(. It looks like this thread may have died on the vine. But what the heck. I'll ask anyway. Is there a reason why you can't simply install the MSCAL.OCX and include it in your references? (C: Program Files (x86) Microsoft Office Office 12 MSCAL.OCX) I have done this on my PC, and it seems to work. Yes, it's a PITA to have to install it on any/all PC's that you have your program on.
But that is just what we seemingly have to endure with Access versioning. Looking in the above directory, it appears that the MSCAL also requires a few related files: MSCAL.CNT, MSCAL.DEP, MSCAL.HLP Perhaps there is an install program that does the whole thing? I am off to research that now.
Apparently Microsoft used to have this available in the download center, but has since removed it.:( It also appears that even if you have the OCX, it has to be added to the Windows Registry before you can use it. I'm not sure I'm brave enough to start messing around. I guess I'm off to the land of application re-design. Thanks MoneySoft.:( Update: Running Windows 7 (64-bit) I have succesfuly downloaded, installed, and registered the OCX file.
And my app is working. Registering it required running an 'Elevated Command Prompt' to use RegSvr32 with Admin privileges. My next experiment will be to create a run-time version of an app that includes this control, and see if Access Developer Extensions' deployment wizard will pick up on the fact that this OCX file is needed, and will include it in the MSI? Wish me luck. A much simpler method of installing a calendar. It appears to the user to function similarly to mscal.ocx but unfortunately the calendar only appears when the date control box is selected.
Nonetheless a workable solution. Thank you I might be wrong.
But the 'date picker' only appears to work with a bound (date-format) control? Therefore not a 'workable solution' for me. My app uses a pair of unbound text-box controls to specify StartDate and EndDate, then creates a staffing schedule report. In order to resolve this issue, just copy the file 'mscal.ocx' into the directory Access has been installed in. Examples: C: Program Files Microsoft Office Office12 mscal.ocx C: Program Files Microsoft Office Office14 mscal.ocx I'm unsure if the file is referenced via a relative path or if it uses the install path, but just inserting the file into the folder containing 'MSACCESS.EXE' seemed to fix the error for me.
Since the error occurred with the first user to upgrade to 2010 in a corporate environment, (earlier than the rest of the users), other machines still had the file available. I'm not sure whether or not an upgrade to Access 2010 will delete the file, so you may have to search for it in order to get a copy.
Hi, I was wondering if I could get some help with the following error when opening a database Access.mdb 'Your Microsoft Access database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0' It is very annoying it comes up everytime you run the database. I have changed the calendar in my database built in Access 2003 (which is working really well) so that it uses the datepicker code obtained from This still does not work. It keeps telling me the same error. I wonder if there is a way of working around this issue. Any help would be greatly appreciated.
Thank you in advance. Hi, Thank you for using Office IT Pro General Discussions forum.
The calendar control is not shipped in Access 2010 for a number of reasons. If you open a form that has mscal.ocx and you will see the following error: “Your Microsoft Office Access database or project contains a missing or broken reference to the file 'MSCAL.OCX’.” To fix this issue, you will need to remove this from your application. Here are some alternatives: 1. Use datepicker. Here is an example on the datepicker- 2.
Use other 3rd-party calendar controls that are available on the Web. Here are a couple of community provided calendar controls: For details, you can refer to this blog: Best Regards, Sally Tang.
Hi, Thank you for using Office IT Pro General Discussions forum. The calendar control is not shipped in Access 2010 for a number of reasons.
If you open a form that has mscal.ocx and you will see the following error: “Your Microsoft Office Access database or project contains a missing or broken reference to the file 'MSCAL.OCX’.” To fix this issue, you will need to remove this from your application. Here are some alternatives: 1. Use datepicker. Here is an example on the datepicker- 2.
Use other 3rd-party calendar controls that are available on the Web. Here are a couple of community provided calendar controls: For details, you can refer to this blog: Best Regards, Sally Tang. It looks like this thread may have died on the vine. But what the heck. I'll ask anyway.
Is there a reason why you can't simply install the MSCAL.OCX and include it in your references? (C: Program Files (x86) Microsoft Office Office 12 MSCAL.OCX) I have done this on my PC, and it seems to work. Yes, it's a PITA to have to install it on any/all PC's that you have your program on. But that is just what we seemingly have to endure with Access versioning. Looking in the above directory, it appears that the MSCAL also requires a few related files: MSCAL.CNT, MSCAL.DEP, MSCAL.HLP Perhaps there is an install program that does the whole thing?
I am off to research that now. Apparently Microsoft used to have this available in the download center, but has since removed it.:( It also appears that even if you have the OCX, it has to be added to the Windows Registry before you can use it. I'm not sure I'm brave enough to start messing around. I guess I'm off to the land of application re-design.
Thanks MoneySoft.:(. It looks like this thread may have died on the vine.
But what the heck. I'll ask anyway. Is there a reason why you can't simply install the MSCAL.OCX and include it in your references? (C: Program Files (x86) Microsoft Office Office 12 MSCAL.OCX) I have done this on my PC, and it seems to work. Yes, it's a PITA to have to install it on any/all PC's that you have your program on. But that is just what we seemingly have to endure with Access versioning. Looking in the above directory, it appears that the MSCAL also requires a few related files: MSCAL.CNT, MSCAL.DEP, MSCAL.HLP Perhaps there is an install program that does the whole thing?
I am off to research that now. Apparently Microsoft used to have this available in the download center, but has since removed it.:( It also appears that even if you have the OCX, it has to be added to the Windows Registry before you can use it. I'm not sure I'm brave enough to start messing around. I guess I'm off to the land of application re-design. Thanks MoneySoft.:( Update: Running Windows 7 (64-bit) I have succesfuly downloaded, installed, and registered the OCX file.
And my app is working. Registering it required running an 'Elevated Command Prompt' to use RegSvr32 with Admin privileges. My next experiment will be to create a run-time version of an app that includes this control, and see if Access Developer Extensions' deployment wizard will pick up on the fact that this OCX file is needed, and will include it in the MSI? Wish me luck. A much simpler method of installing a calendar. It appears to the user to function similarly to mscal.ocx but unfortunately the calendar only appears when the date control box is selected. Nonetheless a workable solution.
Thank you I might be wrong. But the 'date picker' only appears to work with a bound (date-format) control? Therefore not a 'workable solution' for me.
My app uses a pair of unbound text-box controls to specify StartDate and EndDate, then creates a staffing schedule report. In order to resolve this issue, just copy the file 'mscal.ocx' into the directory Access has been installed in. Examples: C: Program Files Microsoft Office Office12 mscal.ocx C: Program Files Microsoft Office Office14 mscal.ocx I'm unsure if the file is referenced via a relative path or if it uses the install path, but just inserting the file into the folder containing 'MSACCESS.EXE' seemed to fix the error for me. Since the error occurred with the first user to upgrade to 2010 in a corporate environment, (earlier than the rest of the users), other machines still had the file available.
I'm not sure whether or not an upgrade to Access 2010 will delete the file, so you may have to search for it in order to get a copy.