MSCom control for Access 2007?

[Ray]

I have an Access 2003 app that uses the mscomm.ocx to communicate with
another device over an RS-232 port. Access 2007 appears to not allow using
the mscomm control. Has anyone else run into this?

 

[Tony Toews [MVP]]

I have an Access 2003 app that uses the mscomm.ocx to communicate with
another device over an RS-232 port. Access 2007 appears to not allow using
the mscomm control.

A killbit was recently set for versions of the MSComm control older
than a few months ago. Do a search at my blog in my sig below for
some more details.

Fortunately folks have stated they've had good luck with the VB code
at the first link at the Serial Port Communications page at my web
site.http://www.granite.ab.ca/access/serialport.htm

Tony

 

[Ray]

Hi,

I took a quick look and it looks encouraging. But I didn't see any mention
of an equivilent to the OnComm event. Do you know if it supports the event
driven model?

Basically I'm logging data received from a device. If it will not generate
an event when data is available, I'm guessing I'll have to set up a timer to
check the receive buffer constantly. Any idea if that's the only option?

 

[Tony Toews [MVP]]

I took a quick look and it looks encouraging. But I didn't see any mention
of an equivilent to the OnComm event. Do you know if it supports the event
driven model?

Basically I'm logging data received from a device. If it will not generate
an event when data is available, I'm guessing I'll have to set up a timer to
check the receive buffer constantly. Any idea if that's the only option?

Sorry, no idea.

Tony