Connecting to mySQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian - 29 Apr 2005 20:16 GMT

We just upgraded some "over-the-counter" software that now
uses a mySQL server instead of individual FoxPro dbf
files. I need read-only access to this data for some
queries and modules I wrote. With the FoxPro tables, I
was able to just link the tables into the Tables section
of my Access database. Should I do the same with the
mySQL tables, or is there a better way?

Thanks to all those who help!

Reply to this Message

Albert D. Kallal - 29 Apr 2005 22:03 GMT

Yes, you should be able to link to those tables, very much like before.

You will of course need correct signon, and permissions. Simply talk to the
people who setup the database, and ask for the odbc drivers..and the correct
settings to connect.

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Reply to this Message