Linking tables

[jduawa]

In access you can link tables between databases....is there any way to link an access table to a mySQL database??

 

[QatQat]

If you mean to use Access as a GUI to MySQL then yes.

Install MyODBC 3.5
you can get it here

http://www.mysql.com/downloads/download.php?file=Downloads/MyODBC3/MyODBC-3.51.06.exe&pick=mirror

Create a new DSN using the newly installed MySQL ODBC Driver


Open an empty Access database and create linked tables using you DSN.

Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[jduawa]

i realize you can link a mySQL table into access but i want to link an access table into mySQL, so that when the access table is updated the mySQL table also reflects those changes.

 

[QatQat]

You can write a Access Macro that exports it into MySQL through an ODBC driver. I doubt that you can link tables the way you want to do it.
It works between Access databases but Mysql is a database server as Access is just a front end with basic db storage functionality; storing master tables on access having MySQL depending on it would be the wrong way of doing it.
Perhaps you should drop Access and develop everything in MySQL.

Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[jduawa]

how would i go about linking one table from one mySQL DB to another table in another mySQL DB