Recommendation for serial communications in Access 2007

Posted by bglenn on Stack Overflow See other posts from Stack Overflow or by bglenn
Published on 2010-02-15T19:00:16Z Indexed on 2010/04/04 14:13 UTC
Read the original article Hit count: 397

Filed under:

serial-port

|

ms-access-2007

I need to communicate with a bar code scanner connected over a serial port in Microsoft Access. In older versions of Access I was able to use a wrapper around MSCOMM32.ocx that no longer seems to work. I can't use wedge communication because I need to use ACK/NACK which is only supported through the RS232 interface and I need to send messages to the scanner, which is also only supported through the RS232 interface.

Are there any controls in widespread use that support serial communication in Access 2007?

EDIT: In case anyone comes across this, the newest version of MSCOMM32.ocx (I believe dated 3/09) still works fine as of this writing. It is older versions of MSCOMM32.ocx that do not work.

© Stack Overflow or respective owner

Related posts about serial-port

Reading a Serial Port - Ignore portion of data written to serial port for certain time

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to read data coming and Arduino on a serial port on intervals. So essentially something like Take a reading Wait Take a reading Wait Take ... etc. The problem I am facing is that the port will buffer its information so as soon as I call a wait function the data on the serial port… >>> More
Serial port game controller (racing pedals)

as seen on Super User - Search for 'Super User'
I have an old madCatz racing wheel for the playstation 2. The gas and brake pedals are connected to the wheel by a serial port. I just bought a usb racing wheel for the PC but it lacks pedals so I wanted to see if I could get these old madCatz working. I just installed the serial port in my motherboard… >>> More
virtualbox in fedora 12 ~ win xp serial port

as seen on Super User - Search for 'Super User'
i have Fedora 12 and VirtualBox 3.1.2 win xp is in virtualbox how to add serial port which will be 'physically' connected to /dev/ttyUSB0 thanx >>> More
Serial Port Not getting closed. I want to release the COM port ...

as seen on Stack Overflow - Search for 'Stack Overflow'
Serial Port Not getting closed. I want to release the COM port ... Below is my code.... import java.io.*; import java.util.*; import gnu.io.*; public class ReadCommPort implements SerialPortEventListener { static CommPortIdentifier portId; static Enumeration portList; InputStream… >>> More
How to use QSerialDevice in Qt?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am trying to use QSerialDevice in Qt to get a connection to my serial port. I also tried QextSerialPort before (which works on Windows Vista but unfortunately not on Windows XP ..) but I need an API which supports XP, Vista and Win7... I build the library and configured it this way: CONFIG… >>> More

Related posts about ms-access-2007

remove autoexec macro from MS Access 2007

as seen on Stack Overflow - Search for 'Stack Overflow'
I have created an autoexec macro in MS Access 2007 and cannot find it! I know its there because it runs, but I cannot find it to delete or modify. I can see other macros that I have created just not the autoexec one. Can someone please point me in the right direction to find where it is located… >>> More
How to connect to MS Access 2007, from Java on a mac

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for a way to connect to a MS Access 2007 database from Java. I don't believe the ODBC way is available to me as I'm writing on a mac and will be pushing this product to Linux. The HXTT drivers also do not work with 2007. Is there a way, a tutorial, an example, etc that accomplishes this… >>> More
Can't change data type on MS Access 2007

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have a huge database (800MB) which consists of a field called 'Date Last Modified' at the moment this field is entered as a text data type but need to change it to a Date/Time field to carry out some queries. I have another exact same database but with only 35MB of data inside it and when… >>> More
Help with Ms Access 2007 Combo boxes

as seen on Super User - Search for 'Super User'
What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form with a query. Here's a example of my scenario: cmbCarMake Behavior: User starts typing, and list… >>> More
MS-Access 2007 Time Online Report

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following data in my database: MemberID | DateTime ------------------------------------- 1 | 31/03/2010 3:45:49 PM 2 | 31/03/2010 3:55:29 PM 1 | 31/03/2010 4:45:49 PM Every time a user is authenticated or un-authenticated this log appears in the database… >>> More