I've configured this before and yes, the process was fairly straight forward. There was just one main gotcha that I found, which was something to do with the autonumber value access uses to create primary keys. Forgive me, it's been probably 5 years and the exact nuances escape me at present.
I like Access a lot and think that an Access/MySQL solution makes a lot of sense. I'll dig around my documentation and see if I can find it. Best of luck, Chris On Mon, Apr 4, 2011 at 4:56 PM, John Abreau <j...@blu.org> wrote: > I've googled this in the past, and I found several HOWTOs that > appeared to indicate that it's fairly straightforward. I never got around > to trying it, though. > > > > On Mon, Apr 4, 2011 at 3:20 PM, Stephen Adler <ad...@stephenadler.com> > 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@blu.org > > http://lists.blu.org/mailman/listinfo/discuss > > > > > > -- > John Abreau / Executive Director, Boston Linux & Unix > AIM abreauj / JABBER j...@jabber.blu.org / YAHOO abreauj / SKYPE > zusa_it_mgr > Email j...@blu.org / WWW http://www.abreau.net / PGP-Key-ID 0xD5C7B5D9 > PGP-Key-Fingerprint 72 FB 39 4F 3C 3B D6 5B E0 C8 5A 6E F1 2C BE 99 > _______________________________________________ > Discuss mailing list > Discuss@blu.org > http://lists.blu.org/mailman/listinfo/discuss > _______________________________________________ Discuss mailing list Discuss@blu.org http://lists.blu.org/mailman/listinfo/discuss
