update MySQL from MS access every 30 seconds

[jr]

I run a website that hosts a webcast for basketball games. I am trying to add live statistics to my site but I'm running into a few problems. I have a program that updates a local MS access database which is hosted on a win2k server that I use as a streaming media host. I would like to update my MySQL database hosted with discountasp with the data found in the access database every 30 seconds. Is there a good way to do this? previously, I've tried generating a page on my media server and having it sent to my webhost. I'm looking for a solution that wont tax my media server greatly as it has to serve hundreds of streaming media connections at the same time.

any suggestions?

thanks

[diltonm]

Hi,

First suggestion is to get rid of Access is performance is an issue. Until you do that and you still use Access you can do what I just did as a test and first create an ODBC connection to your MySQL DB. Then go into Access and create a Linked Table to the MySQL DB via ODBC. From there you're on your own.

At least you'll have access to both the local data and remote data in the same Access database so it should be easy to update data.

I would think the performance would be better to use a local MySQL DB and replicate to DASP periodically. I've not used replication much so that's something I'd have to look into as well.

Good luck!

Dilton