Heres a problem for yall.
Posted: Fri Feb 18, 2005 5:18 pm
Cant figure this one out.
I have two databases, one is an access database, accessed through ODBC. The other one is an mysql database located at another place then the access db. So the problem is that the mysql database needs to be be updated each time a change is made to the access database.
So basicly, I was thinking that I might write some software to take care of the mess, eg a timer that checks if the access database has been updated once every 10 or 20 minutes and then updates the mysql database accordingly. But the thing is that I have this weird fealing that when I´m done writing the software something will come up and my way of doing it will be a rather dumb way of doing things, so my question is; what other choices do I have? Thanks.
I have two databases, one is an access database, accessed through ODBC. The other one is an mysql database located at another place then the access db. So the problem is that the mysql database needs to be be updated each time a change is made to the access database.
So basicly, I was thinking that I might write some software to take care of the mess, eg a timer that checks if the access database has been updated once every 10 or 20 minutes and then updates the mysql database accordingly. But the thing is that I have this weird fealing that when I´m done writing the software something will come up and my way of doing it will be a rather dumb way of doing things, so my question is; what other choices do I have? Thanks.