Access MDB to MySQL Database - Upload Access Database to MySQL

Solution:

Step 1: Install ODBC Driver.

Step 2: Set ODBC Setting in Control Panel

Step 3: Upload Database with Access as following:

  

 

Access MDB to MySQL Database - Table doesn't exist

Type: Access MDB to MySQL Database

Problem: Table doesn't exist.

Solution: 確定 Table Name 大小寫正確。

Access MDB to MySQL Database - Delete / DeleteRecord 出現錯誤

Type：Access MDB to MySQL Database

Problem：執行 Delete / DeleteRecord 出現錯誤

Solution：確定轉到 MySQL 的 Table 皆具備主鍵(Primary Key)，否則執行時會出現錯誤。

Error Message：row cannot be located for updating. some values may have been changed since it was last read

Access MDB to MySQL Database - 查詢 Query 功能

Type: Access MDB 轉為 MySQL Database

差異：查詢/Query 功能

細節：Access 內建的查詢功能，在 MySQL 裡，應以 SQL 指令取代。

 

Solution：

Access：在 Access 中建立 Query Table_A, Tabel_B 並指定關聯欄位為 R_ID

MySQL：select * from Table_A, Table_B where Table_A.R_ID=Table_B.R_ID