cron or Windows Task Manager would work if you want to check the status of the data periodically, but I believe you can also use Access to hit a web address (it doesn't have to display anything) so you could, at time of insert, have Access activate a PHP script on your web server that does the database check.
You could probably get the last inserted ID number as well and pass that to the PHP script if you want to check specific records right after they're inserted. -TG = = = Original message = = = I have an Access database connecting via ODBC to a local MySQL machine and doing inserts. It does these inserts throughout the day. After each insert, I need a PHP program run. Alas, MySQL 4.1 doesn't do triggers, etc., and upgrading to 5.x looks non-trivial. What else can I do? Is there any way to trigger something via the ODBC connection? A cron job? I'm open to suggestions. kind regards, bill ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
