MySQL, ODBC, and Access
scott at domainalchemy.com
Tue Jul 10 23:48:56 PDT 2001
and this time I'll include the link referred to:
Should you choose to forego the route of making MySQL editable through
Access, I've found this app to be a great intermediate step for those of
us that NEED the GUI-
PS- I would love to see the man for the ODBC process (hint, hint) Any
pointers for a good place to start?
> -----Original Message-----
> From: LINUX-owner at u.washington.edu
> [mailto:LINUX-owner at u.washington.edu] On Behalf Of daniel parshall
> Sent: Tuesday, July 10, 2001 3:26 PM
> To: UW Linux Group
> Subject: Re: MySQL, ODBC, and Access
> 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