Solved

msaccess 2010 with msaccess runtime 2k7

Posted on 2010-11-28
13
582 Views
Last Modified: 2012-05-10
I have a new system that has office 2010 installed. I have an access app that is installed as a runtime app that was created in access 2007. when I run the app I get the error  "..missing or broken reference to the file 'MSCAL.OCX' version 7.0".
I know that this .OCX file does not ship with office 2010 but I thought that the runtime library included everything needed to run the app and would ignore any other access installation.
0
Comment
Question by:jsgould
  • 6
  • 4
  • 2
  • +1
13 Comments
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 100 total points
ID: 34226508
Sounds like it does not. I would of thought you might of had an installer for your access app that copies your libs and registers them

Have you tried to copy MSCAL.OCX from an existing working pc (would most likely be under windows\system32), copy it onto the new pc

you might need to register it, if so run this command in dos

regsvr32 \windows\system32\mscal.ocx
0
 

Author Comment

by:jsgould
ID: 34226579
I use the access 2007 Packager to create a windows installer package, which creates the runtime library and installation package. then install on the office 2010 system
0
 
LVL 57
ID: 34226692
<<I know that this .OCX file does not ship with office 2010 but I thought that the runtime library included everything needed to run the app and would ignore any other access installation.>>

  It does not.  It only includes the base items needed to run Access.  The 'runtime' version is nothing more then the full version with design functions disabled.

  So anything you add to a default Access intall (like 3rd party controls), you need to include in your setup in some way.

  Beyond that, not everything that can be used with Access may be distributable legally with the runtime.  For example, if you use calls to some of the Access Wizard code, your not allowed to distribute those the runtime.

  According to the EULA, they are only usable if you have a full retail copy.

JimD.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 34226701
BTW, in the past, MSCAL.OCX was not distributable unless you had purchased a license:

OFFXPDEV: Cannot Redistribute Calendar Control Unless You Have a Microsoft Office Developer License
http://support.microsoft.com/kb/329573

  That's probably changed at this point though as starting with A2007, they started giving the runtime away for free.

JimD.
0
 
LVL 84
ID: 34226882
I have not been able to find anything that says you can distribute the Calendar control if you ONLY have Access 2007. However, if you own earlier versions of the Developer Edition you will have distribution rights. Depending on exactly which of these your are using, you may alos have distribution rights if you own a copy of VB 5/6, or perhaps even one of the early versions of one of the .NET languages.

Note also that these controls will not work reliably on the 64-bit platforms.
0
 

Author Comment

by:jsgould
ID: 34269819
This question is NOT abandoned or inactive. I have not been able to try any of the recommendations yet.
0
 

Author Comment

by:jsgould
ID: 34438996
rockiroads:

tried the copy and register as u suggested, but same error. any other thoughts?
0
 
LVL 84
ID: 34439037
<tried the copy and register as u suggested, but same error. any other thoughts? >

Again: Unless you have the rights to distribute this control - and there's been no indication from you that you have this right - the we cannot assist you with deploying that control. The mscal.ocx file is a copyrighted Microsoft control.

2007 and 2010 have a builtin date picker. Could you not use this instead of the calendar control?

In fact, are you certain that you need the mscal.ocx control, since your app was originally written in 2007? You can try removing the reference and compiling the project (i.e. from the VB Editor, click Debug - Compile AFTER removing that reference). Make a backup of your app before doing this, of course.



0
 

Author Comment

by:jsgould
ID: 34439269
LSMConsulting:

I'm not familiar with the "date picker". I see a calendar control 12.0 in the activex list of controls in a2007. Is this the "date Picker"?  Is it essentially the same thing and if I change to it, is it backward compatible to a2003?
0
 
LVL 84
ID: 34439451
It's not an ActiveX control. In 2007/2010, if you add a field that is bound to a Date field to a form, you can set that form control to automatically show the Date picker whenever the user enters the control:

http://msdn.microsoft.com/en-us/library/gg251104.aspx
0
 

Author Comment

by:jsgould
ID: 34439537
LSMConsulting:

Thank you!
do u have any recommendations/suggestions for 3rd party controls that are similar to mscal.ocx?
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 300 total points
ID: 34439895
The only ones that might work would be the ones from FMS (Total Access Controls). I'm not sure they work in the 2010 environment, however, and as we move into the 64-bit world you'll find that most Ax controls (which are 32-bit) won't work in that environment. Better to avoid the use of those in Access, if you're going to be working with 2010.

You can use API calls to build these, or just use an Access form that looks like a calendar: http://www.granite.ab.ca/access/calendars.htm
0
 

Author Closing Comment

by:jsgould
ID: 34458450
Thanks for all ur help!
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question