Running 07 app in 10 2

[LakotaMan]

Hi All,

I have developed an app in 07 and I have a user who is trying to run it in version 10. He is getting the usual msg:

"Your Microsoft database or project contains a missing or broken refernce to the file 'MSCAL.OCX version 7.0' "

How can I get this app to run for him?

Thank you for any help you can give me on this.

LM

 

[Golom]

MSCAL.OCX is a control that comes with MS/Office. I infer that your user has installed MS/Office 10 and that has probably removed controls from previous versions and replaced them with the Office 10 versions.

Your choices (none of them very attractive) are:

Modify the code on a machine running Office 10, changing the references to MSCAL.OCX to the new one. This may involve dropping the existing occurrences of MSCAL.OCX 7 and replacing them with MSCAL.OCX 10.

Replace the calls to MSCAL.OCX with some more stable calendar control that won't disappear with each new release of Office.

Unfortunately, MSCAL.OCX is not a redistributable control so you cannot legally copy it to the user's machine nor can you include it in an install program.

 

[LakotaMan]

Golom:
You know, I was afraid you'd tell me that. What a bummer.
Thanks for the help, though!

 

[ClientHelp]

I am just discovering the same problem as made the V10 conversion. I have tried to simply remove the ActiveX object and enable the date picker proposed by by MSFT, but it is not working - nothing happens on run time. What are some "stable" calendar controls that can be created so I can use (reuse really) my V7 .mdb file? Since I need to rebuild, may as well build something that lasts

 

[LakotaMan]

The only success I've ever had is with a custom calendar created from an Access form. I will give you the link to the site where you can get it:

http://www.glump.net/content/accessdatepicker

It's not as slick and compact as the MS controls, but by God it's worked for my app through 4 version upgrades!! I'm thinking I may go back to that idea and never use the freakin' MS control again!

 

[ClientHelp]

Thanks for the ref. I have seen this before. Not as slick as the ActiveX controls but works. I moved for Office 2000 to 2003 and even 2007 w/o issues. I guess I got lucky. Very disappointed with MSFT. I guess it was not enough to force everyone to relearn the program from 2003 > 2007. Now, a number of controls have been broken too....sad.

 

[Golom]

... a number of controls have been broken too

Not so much "broken" as "ceased to exist". Access 2010 has deprecated several controls and bits of functionality that existed in earlier releases. Not that that makes the adjustments any easier.

To see what's changed, look here.

 

[LakotaMan]

Golom: Thanks for your input, I am always amazed at the extent to which MS will go to make a unusable any legacy Access programs.