Access : How to Configure Access 2010 to ODBC Phpmyadmin Windows 10

Access : How to Configure Access 2010 to ODBC Phpmyadmin Windows 10
1. Set up mysql-connector-odbc-5.3.6-win32 on windows 10 64bit. mysql-connector-odbc-5.3.6-win64 cannot use
File Set Up On Serve : \\datacenter\Software\#Freeware\Admin\MySQL\odbc
Link Download : https://dev.mysql.com/downloads/connector/odbc/
2. Open Program ODBC Data Sources (32-bit) On Start Menu.
3. Click Add Select MySQL ODBC 5.3 ANSI Driver Or MySQL ODBC 5.3 Onicode Driver On List And Click Finish

4. Setting Server And Enter User Password For Connect Database

5. Click Test Show Success It Worked.

6. Clock Program ODBC By Click OK. Tree Time.
7. Open Microsoft Access 2010 Click Create Database
8. Clock Table By Click Right On Header Table And Select Close

9. Click Menu External Data --> Database ODBC

10. Select Connect To Data And Click OK

11. Select Tab Machine Data Source And Select Data Source Name We Create On ODBC Step 4. And Click OK

12. Select Table We Need To See Or Select All Table And Click OK

13. Click On Left Name Table See Data On Right Finish