We help IT Professionals succeed at work.

MS Access 2010

I'm am upgrading our dbase from Access 2000 to 2010. When I open it I get an error message: Database contains missing or broken reference to the file 'MSCALOCX' version 7.0. I think what means is the calendar app is outdated or not working correctly. How does one go about fixing this problem.
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
That calendar OCX is no longer directly supported in A2010. There is now a built in calendar control that can be enabled for any text box with a date.

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
see image
Capture1.gif
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
btw ... you will need to uncheck the reference cal ocx.

Now, I believe it is possible to still use the ocx in A2010 ... by say putting it in the same folder as your app  (or wherever) and then set a Referece to that location.

mx

Author

Commented:
mx,

Thanks for the help. Bear with me though, I'm not the guy that created the dbase and have limited experience with it other than simple maintenance. That said the 2 things that concern me are: most people in the office will slowly be upgrade from office 2000 to 2010. If I make the change that you point out will it affect how the older versions access to the dbase.

Second question would be could your details be explained more simply. Your fix seems to be exactly what I need but I'm confused as to where I make the change. Is it in a table, or form. And it everywhere a date is use.

glued
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
sure ... which fix ?

Author

Commented:
First question first....most people in the office will slowly be upgraded from office 2000 to 2010. If I make the change that you point out will it affect how the older versions access to the dbase.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Sorry, I'm still not sure which change you are referring to?
Using the old OCX in A2010 or ?

mx

Author

Commented:
I think I'm unsure about using a new OCX in the old A2000.
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
There is no new OCX.  The OCX is what is used prior to A2007.  I'm just saying you *could* ... still use it and subsequently the Calendar Control ... in A2007/10, but putting it in the same folder (best) as the app, and setting a reference to it.

mx

Author

Commented:
Thanks for your help....