Heres a problem for yall.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Anthet
Forum Newbie
Posts: 2
Joined: Fri Feb 18, 2005 5:13 pm

Heres a problem for yall.

Post 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.
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post 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
Anthet
Forum Newbie
Posts: 2
Joined: Fri Feb 18, 2005 5:13 pm

Thanks for the quick reply

Post by Anthet »

I will look into that, I knew I was missing something, ha. Thanks again.
Post Reply