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?

Why not simply create the table on MySQL and link to it? That would always keep the data up to date without any efforts toward synchronizing/replicating not to mention dealing with potentials bugs that could arise in DIY synchronizing.

That is a simple solution, but do you know of any tutorials or any help with that. Setting up the MySQL database is easy, but not sure how to create the macro to export to the other database every 30 min.

If you follow BananaRepublics suggestion then there is no syncronising every 30 minutes.

The suggestion was to create the table on the MYSQL server and create an ODBC connection on your PC's.

Then in access create a linked table and select the MySQL ODBC Connection.

Then select the table you created on the MySQL server.

By doing this it means that the MySQL database and your access database are using the same data... so it's always in sync.

No macros needed at all.

You would go to mysql.com and download the MySQL 5.1 ODBC Driver (here), install it on all computers where it needs access to MySQL server.

Then follow this instruction to link the tables. If needed, you may need to create a DSN.

Be aware about the recommended options to enable for the drivers. Particularly 'returning matching rows'. Timestamp are good thing but not necessary in all cases.

HTH.