I am developing an Access 2007 "project" (.adp) as a front-end to a SQL Server 2005 Express database.
In some of my Access Forms I want to read data sent from a barcode scanner attached to a COM port. I am fairly familiar with the barcode scanner side of things because this is an upgrade of an old DOS application that has been using various scanners for many years.
From what I have found so far on the web, MSCCOMM appears to be the suggested method of doing this. What I'm not so sure about is how I go about getting this installed and operational. Can anyone advise me on how to do this or point me to a relevant article? How do I get MSCOMM installed on my PC and how do I make Access 2007 aware of it so that I can use it in the VBA code behind my Forms?
Many thanks. Colin.