Serial port access

[Tom Healy]

Can anyone help me with serial port access from MS
Access? I have not been able to find any documentation on
accessing the PC's serial ports from Access or from Access
Visual Basic. I need to be able to retrieve a weight
reading from a scale connected to the COM1, or COM2 port
of the PC. Thank you very much for any help you can
provide.

 

[Tony Toews]

Can anyone help me with serial port access from MS
Access? I have not been able to find any documentation on
accessing the PC's serial ports from Access or from Access
Visual Basic. I need to be able to retrieve a weight
reading from a scale connected to the COM1, or COM2 port
of the PC.

See the Serial Port Communications page at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Douglas J. Steele]

Tony Toews has some links at http://www.granite.ab.ca/access/serialport.htm

 

[Thomas Lutz]

With Access there is no easy way to read from the serial port directly
without writing some very complex code that calls the Windows API to
open the COM port.
The easiest way to input serial data into an Access database would be
to use a tool that is designed for the job.
You might want to look at a product called WinWedge from TAL
Technologies at :
http://www.taltech.com/products/winwedge.html

WinWedge is ideal for interfacing a scale or any other RS232
instrument to an Access database.