How to resolve the error "Missing: Microsoft Common Dialog Control 6.0 (SP3) in VBA Reference for application written in Access 2003 and now I open it in Access 2010?

How to resolve the error "Missing: Microsoft Common Dialog Control 6.0 (SP3) in VBA Reference for an application written in Access 2003 and now I open it in Access 2010?

In addition, when I open the application in Access 2010, a message box appears:

Your Microsoft Access database or project contains a missing or broken reference to the file 'comdlg32.ocx' version 1.2.
zimmer9Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kelvin SparksCommented:
Download it from here (provided you're not using 64 bit Access) and install according the the instructions.

https://www.microsoft.com/en-us/download/details.aspx?id=10019


Kelvin
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Are you using the Calendar Control ?
If so that has been replaced with the Data Picker available in any Text Box wherein the Control Source is a DataTime Data Type.

From that KB:

"This package is provided under the terms of the End User License Agreement and is intended for the following customers:
Customers who are Microsoft Visual Basic 6.0 and/or Microsoft Visual Studio 6.0 licensees.
Customers who are not licensees of Microsoft Visual Basic 6.0 nor Microsoft Visual Studio 6.0 but are using older versions of the two Common Controls."

I think this means that to legally use this, yoyu must have a licensed version of an earlier version of Access (say A2003) on your system.
0
Kelvin SparksCommented:
I'd disagree with Joe's last comment. I think it means that you can use it if the control was added in a database developed using a licensed version. This allows an upgrade path despite whoever held the original license.

I do not believe you have to be the license holder.

I would agree that you cannot download the dll and use it to insert a control into an Access 2007 or later database for the first time.

Kelvin


Kelvin
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Of course you have to be a license holder. MSFT has never, to my knowledge, removed the restriction that you must own a valid license to deploy this control. I could be wrong (and I'd love to see the MSFT announcement of that), but from my viewpoint Joe is right, and you can only deploy this control if you were previously licensed to deploy it.

AFAIK, the Calender Control was licensed through VB 5.0 and 6.0, and through certain versions of Access (the Developer Editions) - and those Dev editions contained a particular version of the control, not the same one that was provided with VB.
0
zimmer9Author Commented:
I originally used Microsoft Office Access 2003 (11.8321.8405) SP3 for my application and I now use
Microsoft Access Version 14.0.7145.5000 (32-bit) for this application.

I am also using Windows 7.

The application I am working with does not use the Calendar Control.
0
zimmer9Author Commented:
The application works successfully when I open it in Access 2003.
The errors occur when I open the same MDB type application in Access 2010.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
My bad - I meant the Common Dialog Control. Unless you owned the Developer Edition, or Visual Basic 5.0 or 6.0, then you don't have the license necessary to deploy the control.

That said - many ActiveX controls that worked perfectly fine in earlier versions of Access don't work well (or at all) in 2007 and above. MSFT has never guaranteed compliance with those controls in Access, with the distinct exception of the controls supplied with the Developer Edition (or Extensions, depending on your version of Access). The controls supplied with those editions were specifically designed to work with Access, which does NOT manage ActiveX controls in the same manner as other environments, like VB Classic, Visual C, etc.

Your best bet is to do away with that control, and use either the FileDialog control (which is native to Office, not Access), or do what you need with API calls.

File Dialog: https://msdn.microsoft.com/en-us/library/office/Ff835934.aspx

API: http://access.mvps.org/access/api/api0001.htm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.