mysql and access

[matt-urrlRJtNKRMsHrnhXWJB8w at public.gmane.org (Matt Shields)]

On Mon, Apr 4, 2011 at 3:20 PM, Stephen Adler <adler-wRvlPVLobi1/31tCrMuHxg at public.gmane.org>wrote:

> Hi people,
>
> I believe the answer to my question is yes, but hearing it from one of
> you guys will give me the warm fuzzies... At work, one of the people
> here setup an MS access database application which is quickly turning
> into a nightmare because it does not use a real database as a back end.
> So I'm thinking that perhaps I can help them by setting up some tables
> in my mysql database server I have running which would ease up the data
> entry problems they are having. So the question is, is it feasible to
> have a mysql database running on Linux be used as the back end to a MS
> access database application running on windows? If it is, any gottachas
> that one needs to be careful of?
>
> Thanks!
>
> Steve.
>
>
> _______________________________________________
> Discuss mailing list
> Discuss-mNDKBlG2WHs at public.gmane.org
> http://lists.blu.org/mailman/listinfo/discuss
>


I've never done it and I would never try it because Access does bad things
to data, but I'm pretty sure it's possible.  You need the ODBC driver for
MySQL, then you create an ODBC link to the MySQL db server, then in Access
tell it to open the ODBC tables.