MySQL, ODBC, and Access
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.
More information about the Linux