communication driver

D

dave

hi
can any one suggest how to use communication driver in access?
like it vb we can use mscomm...whts the method in access to use same
facility...
dave
 
A

Albert D. Kallal

The mscomm control should work in ms-access,a nd most example VB6 should
work.

The code syntax in ms-access is in fact the same as VB6, but our forms are
different.

So, usually, by looking at code examples , the ms-comm. control should work
in ms-access.
 
T

Thomas Lutz

You should be able to use the MSComm ActiveX control in an Access
database form however it will require that the form be open the entire
time that you want to do the serial I/O. Another issue with the MSComm
control in Access is that the MSComm control is a "licensed" control
therefore Visual Basic must be installed in any workstation where you
use the MSComm control in an Access database. If you try to use the
MSComm control in Access without having Visual Basic installed in that
same workstation, the control will refuse to load into memory.

You could also write code that does serial I/O directly in an Access
database however it is an extremely difficult thing to do using only
VBA code. It requires some very complex calls to the Windows API and
although I am certain that it is possible, the amount of effort
required to do so would be extensive and probably not worth it.
A better way to go would be to use an off the shelf tool that is
designed for this type of job.
The best one that I know of is called WinWedge from TAL Technologies.'
You can learn more about WinWedge at the following URL:
http://www.taltech.com/products/winwedge.html

WinWedge basically makes it extremely easy to both send and receive
RS232 data directly from within an Access, Excel or any other Windows
program.
 
Top