Register now or log in to join your professional community.
1. Open the Access database that you want to link to MySQL.
2. On the External Data tab, choose ODBC Database.
3. In the Get External Data dialog box that appears, choose Link to the data source by creating a linked table and pressOK
4. The Select Data Source dialog box appears, it lists the defined data sources for any ODBC drivers installed on your computer. Click either the File Data Source or Machine Data Source tab, and then double-click the Connector/ODBC DSN you want to link your table to.
To define a new DSN for Connector/ODBC instead, click New and follow the instructions in Section 5.3, “Configuring a Connector/ODBC DSN on Windows”; double click the new DSN after it has been created.
5. If the ODBC data source that you selected requires you to log in, enter your login ID and password (additional information might also be required), and then press OK.
6. Microsoft Access connects to the MySQL server and displays the list of tables that you can link to. Choose the tables you want to link to (or click Select All), and then click OK.
7. If Microsoft Access is unable to determine the unique record identifier for a table automatically, it will ask you to choose a column (or a combination of columns) to be used to uniquely identify each row from the source table. Select the column[s] to use and click OK.
Once the process has been completed, you can build interfaces and queries to the linked tables just as you would for any Access database.
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.