Modems and Access2003

Using Access2003 I've set up a frontend/backend app that uses a modem
triggered from the frontend.
When an operator scans a job out, the app calls the transportation
person's beeper and places the part number and location into his
beeper, his queue for pickup.
This works great for the one location, but, I now want to put this app
on the companies Intranet where many location's in/out transactions
will be received into the backend which resides on the shared drive.
Instead of having a modem on each frontend PC, is there a way I can
have one remote PC do all the modem work.
Using the server is not an option.

Thanks RICK

re: Modems and Access2003

2D Rick wrote:[color=blue]
> Using Access2003 I've set up a frontend/backend app that uses a modem
> triggered from the frontend.
> When an operator scans a job out, the app calls the transportation
> person's beeper and places the part number and location into his
> beeper, his queue for pickup.
> This works great for the one location, but, I now want to put this app
> on the companies Intranet where many location's in/out transactions
> will be received into the backend which resides on the shared drive.
> Instead of having a modem on each frontend PC, is there a way I can
> have one remote PC do all the modem work.
> Using the server is not an option.[/color]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Just a guess: You'd have to use a WinSock control to call a service
object on the computer that has the modem. There'd be a service object
(probably a .COM object using another WinSock control) on that computer
that would be waiting for info from computers on the network. The
service object would receive the info & dial the modem & send the info.

For info on the Winsock .DLL file:

http://support.microsoft.com/default...b;en-us;122928

Examples of using Winsock:

http://support.microsoft.com/default...b;en-us;214397
http://support.microsoft.com/default...b;en-us;209905
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQx9JvoechKqOuFEgEQKVvQCg0ubD8CxuMcWdtrMY/G1DIqqPvCsAoJ+Q
WbzWvwzh5Fzrx0i+NieyaBfH
=crY8
-----END PGP SIGNATURE-----

re: Modems and Access2003

I assume that all the intranet transactions to be sent will be stored
in one BE table
and that you have a FE function that reads the contents of the BE table
and uses the modem to send the info

so if only one front end has a modem, then only one front end will
extract and send data from the BE table

re: Modems and Access2003

Thanks I'll investigate WinSock

re: Modems and Access2003

This sounds too easy so it'll probably work.
All FE's load one BE on the server.
The one PC with modem will be a dedicated machine.
Are you saying I should use the timer event in the FE to check for new
records in the BE?

re: Modems and Access2003

what triggers the front end now, scanning ?
if so, than yes, have a timer event on your main form (that never
closes), look for calls to make