Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-21-2019, 04:59 PM   #1
AN60
Newly Registered User
 
Join Date: Oct 2003
Posts: 283
Thanks: 1
Thanked 5 Times in 5 Posts
AN60
Access 2019

I purchased Access 2019, with Office 2019. All my Access 2007 Db's, except one, work ok.

When I open the problem Db I get a message "Missing or broken Reference to file MSCAL.OCX v7, Fix the reverence".
Then Access opens up just about all vBasic tabs, which makes my job of finding the problem more difficult. I made this Db many years ago and it has never given a problem in 2007. It seems like it's referring to something in the switchboard.

Can anyone give me a heads up, where to start looking, I haven't done much in Access for some time and my memory of my Db's is a bit vague.

Cheers
Dave

AN60 is offline   Reply With Quote
Old 06-21-2019, 05:25 PM   #2
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 2,125
Thanks: 3
Thanked 462 Times in 455 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: Access 2019

Search something like missing MSCAL.OCX reference and you'll get something like
https://community.spiceworks.com/how...ft-access-2010
Cronk is offline   Reply With Quote
Old 06-21-2019, 07:24 PM   #3
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 806
Thanks: 10
Thanked 162 Times in 156 Posts
Micron will become famous soon enough Micron will become famous soon enough
Re: Access 2019

That's a 7 year old article. Maybe just archive the affected forms then from copies, remove the control from whatever forms are using it? It's not worth the hassle IMHO, especially in a multi user environment involving multiple front ends. A common fix is to either use your own calendar form (tons of free examples) or just go with the built in calendar that's accessible from a standard textbox.

__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 06-21-2019, 11:26 PM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,839
Thanks: 107
Thanked 2,665 Times in 2,438 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: Access 2019

The old calendar control was deprecated in A2010 and doesn't work in 64-bit Access.
If you don't like the built in date picker, I recommend my Better Date Picker
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 06-22-2019 at 12:25 AM.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
AN60 (07-15-2019)
Old 07-15-2019, 07:58 AM   #5
AN60
Newly Registered User
 
Join Date: Oct 2003
Posts: 283
Thanks: 1
Thanked 5 Times in 5 Posts
AN60
Re: Access 2019

Thanks for the reply s. I've been busy on other issues and haven't had time to come back here.

I have solved the issue of the following message in my new Access 2019 db; "Missing or broken Reference to file MSCAL.OCX v7, Fix the reverence".

I have several Office 2007 dbs running perfectly in 2019, all using the old calendar, which I/we thought was the culprit in one of my old dbs. I removed the calendar and all references to it and still the thing would not open in 2019.

After a bit of hair pulling, I opened a new db in 2019 and imported the tbls, qrys, forms & reports, one at a time. The idea was to see where the problem was. Here's the strange bit, everything worked with the exception of the old Switchboard. After making a new Switchboard in 2019, I now have the db up & running.

Isladogs
Thank you for your link to the new date picker, I think I'll have a look at it and maybe add it to my dbs over time.

Dave
AN60 is offline   Reply With Quote
Old 07-15-2019, 10:52 AM   #6
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,107
Thanks: 81
Thanked 1,601 Times in 1,485 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Access 2019

I know you have it fixed so this is merely an after-the-fact comment. Your fix points to the possibility of having had a small amount of object corruption in the older version. The "Import to a new DB" fix pretty much assures that you get rid of object corruption.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrading from 2003 to 2019 RKWM Reports 7 06-01-2019 03:38 AM
Access 2019 works differently? CanuckBuck Forms 9 05-13-2019 09:48 AM
Compliance Database design in Access 2019 picasso87 General 11 04-19-2019 06:04 AM
What languages to learn in 2019 MushroomKing The Watercooler 2 12-01-2018 02:28 PM
Office 2019 announced isladogs General 7 09-29-2017 04:03 AM




All times are GMT -8. The time now is 08:09 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World