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.
jrmcanada2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

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

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
Databases

From novice to tech pro — start learning today.