2. A PC behind a firewall ?The PC is not visible to the Web Server - there is no route from the Web Server to the PC.
Access just parses the text input file and generates a text output fileThen why are you using Access - parse files can be done on the server using PHP - what is it that specifically requires Access?
The PC is not visible to the Web Server - there is no route from the Web Server to the PC.
I think you're about to find out how slow network and internet connections can be.Correct, and i've just abandonned my target of 1 second!
I believe that you would actually save development time by learning how to use PHP/MySQL to do your project on the web server.Yes that's possible. I just started learning PHP and surprised how easy it is to get going.
I have seen people use asp to connect to access.
Depending on the exact need, a form timer event could possibly be used.
But truthfully, if you want the event web form driven and not wasting resource then I'd use proper web technologies (PHP, .net, ...).