• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 49
  • Last Modified:

Reading a COM port from an Access 2003 database

I have an Access 2003 database running on a Windows 10 computer. As it is right now, the database is running fine.

However, the client now wants me to add a feature that requires the database to read a COM port. In the past (waaaaay in the past ... so long ago that I don't remember what version of Access I was using), I had to read a COM port in a different database and I did so by adding the Microsoft Communications control. When I go to add an ActiveX control to this database, I see Microsoft Communications Control, version 6.0 as one of my options. But when I select it, I get this error:

Microsoft Office Access doesn't support this ActiveX control

So my question is: how do I read a COM port from Access 2003 on a Windows 10 computer?

Thanks.
0
jrmcanada2
Asked:
jrmcanada2
  • 2
1 Solution
 
aranaCommented:
Make sure you are not trying to use a 32 bit version of the ocx in a 64bit installation or viceversa, also check if you have more than one version of the control in different folders, register one of the (regsvr32) rename the others , try, test, repeat. google for a different version or copy it from another PC
0
 
jrmcanada2Author Commented:
The control is MSCOMM32.OCX and it's in the SYSWOW64 folder. The PC is running Windows 10 (64-bit) and 32-bit Access 2003.

Do I need the 32-bit version of the ActiveX control or the 64-bit version?

Am I right in assuming that MSCOMM32.OCX is the 32-bit version?
0
 
jrmcanada2Author Commented:
P.S. There are no other MSCOMM*.OCX files on the computer
0
 
Fabrice LambertFabrice LambertCommented:
MScomm32 OCX has been deprecated by Microsoft.

There exist some alternative, like using API.
Check the link below:
http://www.thescarms.com/vbasic/commio.aspx
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now