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:

1. Open the frontend MySQL Training DB.accdb application; we no longer need the old backend database.
2. If any forms are open, close them.
3. Rename the Users table in MS Access to zUsers. This way, we can have both tables available for comparison before we remove...