Access VB and Serial Communication

[MikeS]

Once again I'd like to post this question.

Can anyone tell me if Access VB has the capability sending and receiving data
via serial/comm port and if so where can I find some sample code that shows
me how to accomplish this?

Thanks,

Mike

 

[David Lloyd]

Mike:

One alternative is to use the MSComm control. The following articles may be
a good reference, depending on your exact needs.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/comm98/html/vbobjcomm.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;194922
http://support.microsoft.com/default.aspx?scid=kb;en-us;194923
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/comm98/html/vbobjcommx.asp
http://msdn.microsoft.com/library/d...-us/comm98/html/vbidxcommcontrolconstants.asp

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Once again I'd like to post this question.

Can anyone tell me if Access VB has the capability sending and receiving
data
via serial/comm port and if so where can I find some sample code that shows
me how to accomplish this?

Thanks,

Mike

 

[MikeS]

Thanks for your imput, David. There were some interesting articles and tips,
however, they seem to be for "stand alone" versions of VB rather than VB for
applications. Specifically, what I'm trying to do is receive data from a PLC
and store it in a database (either Access or SQL) using Access 2003. I can't
seem to find anything that is user friendly or an easy solution. I also ran
across an ActiveX Control (MSComm), however the sample code I found with it
would not work with Access 2003. Do you have any other sugggestions?

Thanks,

Mike