MySQL, ODBC, and Access

daniel parshall parsh at u.washington.edu
Tue Jul 10 15:26:07 PDT 2001



On Tue, 10 Jul 2001, M. Oesterwinter wrote:

> We have a web-site that will soon be sticking data into a MySQL database.

> The people that need to create querries for the database do not use Unix

> or MySQL, but are quite familiar with Access. From what I understand, you

> can use ODBC to link MySQL and Access. Am I correct? Would this allow

> you to use Access on a client computer to navigate and create querries on

> a MySQL database on a server? I am assuming that there is no need to

> sync the database to the client computer? How well does this solution

> work in real life situations?


You can use ODBC to link MySQL with Microsoft applications (including
Access & Visio). This would allow you to use Access on a client computer
to manipulate a MySQL database located on a server. If you choose to link
tables, then Access keeps in sync with MySQL.

-Daniel



More information about the Linux mailing list