Solved

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

Posted on 2009-07-09
6
2,325 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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now