Linking Access to MySQL issues

[tjjazzyjeff]

I have converted my MS Access database tables to MySQL Server tables. I am trying to use the MS Access front end to cooperate with the MySQL Backend database. I have created a system DSN, without problems.

My issue is when I Open MS Access --> Open File --> Files of Type: ODBC Databases, nothing happens. It does not give me the option to connect to the MySQL database I just created. I also tried to import data by linking tables (again, choosing the ODBC databases option), and it does the same thing. Does anyone know what I may be doing wrong?

 

[Dreamweaver]

Have you downloaded and installed the MYSQL ODBC Driver If not that's your problem go to the mysql site and download the connector.

mick

 

[ByteMyzer]

Dreamweaver, without the MySQL ODBC Driver, tjjazzyjeff would not have been able to create the System DSN. That's not the problem.

tjjazzyjeff, you say that when you open ODBC Databases, nothing happens. Do you mean ABSOLUTELY NOTHING happens, or does it show you the Select Data Source dialog box, with the two tabs, File Data Source and Machine Data Source? If it does, make sure to click on the Machine Data Source. This will show you the list of System DSNs on your machine. If, as you say, NOTHING happens, not even the dialog box, then you have a problem with your Access installation not related to MySQL.

 

[tjjazzyjeff]

You are correct, I have the connector. That is not the issue. When I open ODBC DataSources, I do not get the option to connect to the database I created, access just opens a new database.

 

[ByteMyzer]

If you've already created an Access database, with links to the MySQL tables, don't use ODBC Databases; use Microsoft Access and select the Access database. Opening ODBC Databases always creates a new MDB file.