I am trying to save my my relationships I created in MS Access to convert to MySQL. I have successfully converted all the tables, but getting the relationships over is another thing. I am not very skilled in MySQL. Any help here?
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.
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...