Page 1 of 1

Heres a problem for yall.

Posted: Fri Feb 18, 2005 5:18 pm
by Anthet
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.

Posted: Fri Feb 18, 2005 5:31 pm
by Burrito
if you have MyODBC set up for your MySQL server you can just create an "external data" table that links right into your mysql db. Then when you update your access db, you're actually updating the mysql (right on the fly)...

it won't work with date fields (and possibly others) cause access and mysql don't talk the same date language.

I just did this exact same thing not more than two weeks ago.

Burr

Thanks for the quick reply

Posted: Fri Feb 18, 2005 5:36 pm
by Anthet
I will look into that, I knew I was missing something, ha. Thanks again.