Linking to your tables and views
Some things can cause issues when you're linking tables to MS Access. Some of the tables you just migrated have been set up to highlight these problematic situations, and we will show you how to get around them. It is not difficult, but first, we will start with a table with no problems so that you can see how it should happen.
Exercise 9.05 – linking a good MySQL table to Access
Previously, you exported the User table from Access into MySQL. Although it is no longer in Access, your company's business analysts would still like to be able to view it in Access. To achieve this, you will need to link the table in Access. Follow these steps to complete this exercise: