I am relatively new at this and have a situation that I hope I can find a solution for. So here goes. I have a MySql db that I run on a winNT box with Apache and PHP. This is working well. On the same box I have MS Access running with table links to the MySql db and table links to other Access tables. All the access tables are to sync to our palmpilots. Thru an active X I can send data to and from the palms to the Access tables. Now here is the question. I need to update the Access linked tables anytime the MySql tables are changed. Right now I have Access queries to do this and have to do this each time a palm syncs. Is there a way with PHP and or MySql to update the access tables?
Thanks
Ed Lentz
