exporting to ODBC/MYSQL question

[SGT68]

I have created a medium sized Access app, and I want the database on a server for the advantages that gives, and retain the Access front end. For me MYSQL is the natural choice as i have used it before. SQL server i don't really know. I have MYSQL server/Phpmyadmin and the Mysql odbc drivers at hand.

I need to know if i am going the right way about things:

1. I have created a new empty database in mysql with phpmyadmin
2. with windows i created an odbc mysql flavoured system dsn for this new empty db
3. Gone into Access and for each table in my app : export->odbc database->to the dsn i created.

(the tables and data are showing up in mysql fine

4. In Access create a link(this time) back to the mysql odbc dsn i created

Am i effectively using a MYSQL database? By initially exporting to the ODBC dsn did i create the equivalent of a mysql database?

 

[pbaldy]

Sounds like you did it correctly. You should see a little arrow next to the table icon, indicating it's a linked table. Hovering over a table would show the source, as would the Linked Table Manager.

 

[SGT68]

Sounds like you did it correctly. You should see a little arrow next to the table icon, indicating it's a linked table. Hovering over a table would show the source, as would the Linked Table Manager.

Oh good, an MVP says i did it correctly! Thanks a lot, friend

 

[pbaldy]

Oh good, an MVP says i did it correctly! Thanks a lot, friend

Ha! MVP <> "knows everything"

If you're seeing the arrow icons next to your tables, they are linked and the data is in MySQL. A good test would be to add or modify a record in your linked table in Access then check it in MySQL.