Share via

Mcrosoft Access going from 2007 to 2016

Anonymous
2018-08-29T15:24:58+00:00

The group I am involved with has an Access DB originally created as an mdb file and was subsequently converted to accdb format for use in Access 2007 where is seems to work fine. We have now acquired Access 2016 but have so far been unable to open the file under 2016. We get the following message:

 'Your database contains a missing or broken reference to the file MSCAL.OCX version 7.0. To ensure your database works properly You must fix this reference.'

When I follow the instructions by going back to Access 2007 , opening the db in Design mode, opening Visual Basic and checking the references, there is no MSCAL.OCX file in the reference list. So I can't add it or delete it.

Any idea as to what I do next?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-08-29T16:29:46+00:00

    The old version of Access offered you the use of an ActiveX Calendar control.  In the newer version this is not longer the case.  You would need to edit the design of the relevant form to remove the offending controls.  Then I'd recommend you use one of the control found at

    http://www.devhut.net/2010/06/10/ms-access-calendar-date-picker-control/

    http://www.devhut.net/2017/06/17/great-access-tools-calendar-controls/

    You may also like to review other discussion about this issue, such as

    https://answers.microsoft.com/en-us/office/forum/office_2010-access/2007-access-file-cannot-be-opened-in-2010-access/05567727-3910-4007-a4e2-2578f1002f87?db=5

    https://www.experts-exchange.com/questions/27233347/Your-Database-or-project-contains-a-missing-or-broken-reference-to-the-file-'MSCAL-OCX'-version-7-0.html

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-08-29T15:56:12+00:00

    Check here and see if it helps...

    https://www.access-diva.com/d5.html#bmConversionAlert

    0 comments