Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

mysql and access



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.





BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org