I am trying to have my access database export a specific table to a database located on a different server.
We want to be able to send data from our access database to our web designers MySQL database, but here is the tricky part. We want our access database to be able to send this data to the other database (not housed on any of our servers) every 30 min or so to keep the designers data that they are using updated consistently.
Is there any solutions for this?