Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Why is an MSCOMM control in my Access application no longer supported by my application?

Posted on 2009-07-09
6
2,411 Views
Last Modified: 2013-11-28
I am developing an Access 2007 "project" (.adp) as a front end to a SQL Server 2005 Express database.

A couple of months ago I got myself sorted with "MSCOMM32.OCX" that allowed me to add a "Microsoft Communications Control V6" Active X Control to an Access Form, which in turn allowed me to read input from a barcode scanner attached to the COM1 serial port.

That all worked OK, but now that I am returning to do final testing, it seems that the control is not working.
I get a run-time error when I try to open the Form that contains the control and initialise its settings (error # 438, "Object doesn't support this object or method").
When I look at the form in "design mode", the control appears as a plain white box, as opposed to the "telephone icon" that I think appeared previously.
When I try to add a new MSCOMM control to my form I am told that my project "doesn't support this ActiveX control".

In my VBA Editor's "Tools - References" list, the "Microsoft Comm Control 6.0" box is ticked.

Can anyone explain why this control appears to have become disabled and how I can make it active again?
0
Comment
Question by:colinasad
  • 3
  • 2
6 Comments
 

Accepted Solution

by:
colinasad earned 0 total points
ID: 24815528
On other web-sites I have discovered that a recent Microsoft update might have caused this problem.
Some say that the older version of MSCOMM32.OCX has had its "kill bit" set by update "kb969898" (which was installed on my system on 28th June).
Suggestions are to roll back the update, download an new version of MSCOMM32.OXC, or use a completely different method to read/write to the serial ports.

Any further information or suggestions from EE contributors would still be welcome.
0
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24817047
tony's Microsoft Access Blog (URL 1) recommends replacing MSCOMM32.OCX with API (Application Programming Interface) code and links to a Serial Port Communication page (URL 2) where you can download VB source code to use the API.
1. http://msmvps.com/blogs/access/archive/2009/06/14/an-older-version-of-mscomm32-ocx-has-had-the-quot-kill-bit-quot-flag-set.aspx 
2. http://www.thescarms.com/vbasic/commio.aspx 
I hope this helps.
-chuck wood
0
 

Author Comment

by:colinasad
ID: 24821372
Thanks, Chuck.
It was at Tony's page that I got my further info and downloaded the VB source for using API.
I must say I find this all very frustrating. I am currently revamping a DOS application that has run for the past 25 years and has been reading barcode scanner input from serial ports for last 15 years without a problem.
I thought that moving to Access/VBA would introduce me to much more modern and simpler routines but it seems to be the opposite. I find it incredible that Microsoft would issue an "upgrade" that disables what 4 months ago was the recommended way of reading serial ports in VBA applications. There must be thousands of applications affected by this.
I might look into using USB scanners and try to persuade my client to replace their serial scanners.

Regards. Colin.
0
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.

 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24822434
You are welcome, Colin.
0
 

Expert Comment

by:Mckenzma
ID: 24874499
I am having the same problem, i.e. an MSCOMM control in my Access application no longer is recognized.  Reading the blogs / links referenced above, it appears that Microsoft's action is in response to an identified vulnerability (CVE-2008-0024).

I have rolled back the update. MSCOMM control works as usual now.  Will be circumspect in connecting to the internet on the host laptop until I can re-write the application code and re-install the update.
0
 

Author Comment

by:colinasad
ID: 24877930
Thanks, McKenzma.

I also read that rolling back the update would get MSCOMM working again but decided I would be swimming against the tide.
I reckoned it was time to make the move from serial ports to USB. Just hope my client can agree to updating/replacing their existing serial scanners.

Cheers. Colin.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
AddNew causes duplicate key in VBA Access 12 32
table joins in qry 17 61
Sum in Split Form 17 27
MS Access Is there any color designs besides just flat colors? 3 16
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

808 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