Need Help with linking tables from Access to MySQL

[Robert Manshack]

I've been trying to put all the pieces of the puzzle here concerning Access as a front-end and MySql as a backend. From what I've read everyone just says use the link table manager. But how do you get the tables from your existing access app to mysql? ok, figured that one out next. So now my problem is this. Take Northwind for example. All the queries, forms, etc are looking for tables that already exist. If you migrate the tables out it's just making a copy of the tables. When you link those tables now you have "Customers" and "copy_of_customers" in your table view. How do I change all those relationships from "Customers" to "copy_of_customers"? I've even used the split database option in Access and then tried to alter the links using the Linked Table Manager but it only lets you select .mdb files. You only get the option to import external data from an ODBC connection with a new link. You can't change the existing link from mdb to mysql. any advice?