How can I use Microsoft Access to connect to a MySQL server on another machine and when I change table data on Access, it will be automatically updated on the MySQL server?
I've seen this done, I just don't know how to set it up!
Thanks for your help.
Josh