Connecting to mySQL

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

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!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
MySQL tables 1
MM/DD/YYYY appears as time when using update query 1
Access for MySQL data reports only 5
Filtering on Linked Tables 1
Help with insert using MySql 1
AutoNumber question - MySQL for Access Forms 1
VBA Code to Connect and Query a MySQL Table 12

Back
Top