help fast!

[DoobyWho]

Okay, i've got an access database that i got from someone. They want to be able to update their access database and in turn, have it update their mysql database. How would i set up the database so that it sends the records from the Access database into the correct fields on the MySql database? I know it has something to do with setting up a ODBC connection. But i dont know anything more then that.

[abstrakt]

Google amigo

http://www.convert-in.com/acc2sql.htm

http://www.nusphere.com/products/access2mysql.pdf

http://www.geocrawler.com/archives/3...1/1/0/5068879/

http://www.msfrontpage.net/fp/dbmysqlodbc.htm

http://www.nusphere.com/products/access2mysql.pdf

[DoobyWho]

Thanks.But those are programs. There is a way to do it with only Access/MyODBC and MySql.

[enygmadae]

this help?
http://www.geocrawler.com/archives/3...1/1/0/5055319/
http://codewalkers.com/seecode/48.html

[abstrakt]

Here, try this tutorial then.

Here's a quote from it:
"In this article, I’ll demonstrate just how easy it is to install and configure MyODBC and subsequently use Microsoft Access to manage MySQL data."

http://www.devshed.com/Server_Side/M...DBC/page1.html

[abstrakt]

Originally posted by enygmadae
this help?
http://www.geocrawler.com/archives/3...1/1/0/5055319/
http://codewalkers.com/seecode/48.html

The codewalker tutorial is going from MySQL to Access, he wants to go from Access to MySQL and maintain the data structure.

I'd like to see him get this figured out, maybe he can go backwards on the codewalker tutorial ?

[enygmadae]

yeah, that's what I was figuring....*shrug* always good to have more than enough information than not enough.

[abstrakt]

Originally posted by enygmadae
yeah, that's what I was figuring....*shrug* always good to have more than enough information than not enough.

Roger that, I 100% agree.

[DoobyWho]

Thanks! that helped alot!

[abstrakt]

which one ?