Our orders database exists inside our firewall but we have a web site hosted
on an ISP server. If we wanted to give users the ability to query the
status of their order in real time, we could just export a simple subset of
data to our ISP, like customer name, order ID and status.
Anyone ever do this?
For example, if the status changed from REQUEST to QUOTE or from QUOTE to
PRODUCTION, the AfterUpdate event of the Access application running behind
the firewall would need to send that new information to the ISP.
What I'm thinking is that there could be a page at the web site for
processing the data, that would have an address like this ...
http://www.myISP.com/CustData/update...23456&status=9
The ASP page on the remote, ISP server could process this and update the
status for this order, but how can I, from my Access client application
"navigate" to this address? ... that is to say, pass these simple
parameters to the ASP page on the web server that will update my remote
database, keeping it in synch with my master orders database?
As usual, any suggestions appreciated. (Do I need to mention that the
suggestions should be relevant and not along the lines of my getting a hair
cut or losing weight? For that kind of advice, I have a wife.) Thanks
--
Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast