Re: Help Can Access Control a Relay?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Steve wrote:

I am trying to develop a data control application that will have to switch on and off some relays in the real wold! i anticipat this to be with the com port or printer port!
dos any one know how to make MS Access conect to these ports and control them! so i can switch these relays on and off!
or any other sugestions that will work?

Steve


Pretty easy would be an Access Macro that includes a "RunApp" action (you have to feed it a command line) or a "RunCode" action (you feed it the name of a VBA function).

For example, if you create a file "x1.bat" containing this line:

  echo Hi, there!>COM3:

and a Macro [M_Sendit] containing this action:

  RunApp c:\x1.bat

then running [M_Sendit] will send stuff to port COM3: .

  -- Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx>
  Please feel free to quote anything I say here.
.

Relevant Pages

  • Re: [SLE] Reset LPT Port on Startup
    ... one of the relays are opened. ... > extra device connections without using multipliers. ... printer port is the printing subsym. ... activation occurs only when entering run level 5, the hot-plug software ...
    (SuSE)
  • Re: race condition? between relays and 89C51 uC
    ... relays should remain off. ... all the relays turn on momentarily and then ... Perhaps you're configuring the port direction as outputs, and then writing the port value as '1', instead of writing the port value first? ...
    (comp.arch.embedded)
  • Re: is this the place for a newbie question?
    ... would you suggest as a circuit to control 5v input from the port to 56vdc ... I have tried relays but they are too slow to get the stepper to the ...
    (sci.electronics.basics)
  • Re: BT Broadband - Port 25
    ... information about whether BT Broadband intercepts port 25 traffic. ... By "intercepts" I mean whether BT blocks, redirects or transparently proxies outgoing port 25 connections destined for servers beyond BT's infrastructure. ... Here at IDNET and formerly also claranet I could send as anybody, provided I sent via their relays and belonged to their IP pool. ...
    (uk.telecom.broadband)
  • Re: Change COM port
    ... > XP is the result of quantum leaps forward since those heady days of DOS ... > tinker/tweak the system.. ... > and again with some crap that just might recover 6k of wasted memory and ... >> be set, and sometimes jumpered, for appropriate COM port. ...
    (microsoft.public.windowsxp.basics)