我正在将数据库从Microsoft Access数据库转移到MySQL工作台。所有的步骤都很顺利，但在传输批量数据的最后一步，我陷入了错误。
错误=确定要复制的行数：从源表获取行计数时出错，wbcopytables退出，代码为3221225477失败。
这里有错误日志：
Starting...
Prepare information for data copy...
Prepare information for data copy done
Determine number of rows to copy....
Counting number of rows in tables...
wbcopytables.exe --count-only --passwords-from-stdin --odbc-source="DSN=eastern_backend" --source-rdbms-type=MsAccess --source-timeout= --target-timeout=None --table-file=C:UsershatimAppDataLocalTemptmputmjo05c
--table "tblShippingMethods"
21:45:33 [INF][ copytable]: --table "tblUsers"
21:45:33 [INF][ copytable]: --table "ezr_Report Groups"
21:45:33 [INF][ copytable]: --table "tblPayments"
21:45:33 [INF][ copytable]: --table "tblCalendar"
21:45:33 [INF][ copytable]: --table "ezy_GroupPermissions"
21:45:33 [INF][ copytable]: --table "tblErrors"
21:45:33 [INF][ copytable]: --table "tblErrorLog"
21:45:33 [INF][ copytable]: --table "tblReturns"
21:45:33 [INF][ copytable]: --table "tblInvoiceStatus"
21:45:33 [INF][ copytable]: --table "tblAdjustments"
21:45:33 [INF][ copytable]: --table "tblInvDetailsWithInv#"
21:45:33 [INF][ copytable]: --table "ezy_Users"
21:45:33 [INF][ copytable]: --table "tblCreditCard"
21:45:33 [INF][ copytable]: --table "eza_Preferences"
21:45:33 [INF][ copytable]: --table "ezr_Report List"
21:45:33 [INF][ copytable]: --table "tblReportList"
21:45:33 [INF][ copytable]: --table "tblShippers"
21:45:33 [INF][ copytable]: --table "tblItems"
21:45:33 [INF][ copytable]: --table "tblEmployeeTitles"
21:45:33 [INF][ copytable]: --table "ezr_Report Definitions1"
21:45:33 [INF][ copytable]: --table "tblInvoiceDetails"
21:45:33 [INF][ copytable]: --table "tblProductCategory"
21:45:33 [INF][ copytable]: --table "tblBillOfLading"
21:45:33 [INF][ copytable]: --table "ezr_Report Definitions"
21:45:33 [INF][ copytable]: --table "tblPODetails"
21:45:33 [INF][ copytable]: --table "ezy_Permissions"
21:45:33 [INF][ copytable]: --table "tblCustomers"
21:45:33 [INF][ copytable]: --table "tbl_Dates"
21:45:33 [INF][ copytable]: --table "ezr_Report List1"
21:45:33 [INF][ copytable]: --table "tblSupplierType"
21:45:33 [INF][ copytable]: --table "ezy_GroupUser"
21:45:33 [INF][ copytable]: --table "tblReceipts"
21:45:33 [INF][ copytable]: --table "tblSuppliers"
21:45:33 [INF][ copytable]: --table "tblPOMaster"
21:45:33 [INF][ copytable]: --table "tblTerritory"
21:45:33 [INF][ copytable]: --table "ezy_AuditLog"
21:45:33 [INF][ copytable]: --table "tblEmployees"
21:45:33 [INF][ copytable]: --table "tblCompany"
21:45:33 [INF][ copytable]: --table "tblInvoices"
21:45:33 [INF][ copytable]: --table "ezr_Report Print Queue"
21:45:33 [INF][ copytable]: --table "ezy_Groups"
21:45:33 [INF][ copytable]: --table "tblBillOfLadingDetails"
21:45:33 [INF][ copytable]: --table "tblRelations"
21:45:33 [INF][ copytable]: --table "tblProducts"
21:45:33 [INF][ copytable]: --table "tblStates"
21:45:33 [INF][ copytable]: --table "tblPalletType"
21:45:33 [INF][ copytable]: Opening ODBC connection to [MsAccess] 'DSN=eastern_backend;PWD=XXX'
21:45:34 [INF][ copytable]: ODBC connection to 'DSN=eastern_backend;PWD=' opened
Loading table information from file C:UsershatimAppDataLocalTemptmputmjo05c
ROW_COUNT::"tblShippingMethods": 3
ROW_COUNT::"tblUsers": 21
ROW_COUNT::"ezr_Report Groups": 1
ROW_COUNT::"tblPayments": 122296
ROW_COUNT::"tblCalendar": 242
ROW_COUNT::"ezy_GroupPermissions": 43
ROW_COUNT::"tblErrors": 1
ROW_COUNT::"tblErrorLog": 5822
ROW_COUNT::"tblReturns": 4
ROW_COUNT::"tblInvoiceStatus": 2
ROW_COUNT::"tblAdjustments": 1
ROW_COUNT::"tblInvDetailsWithInv#": 529790
ROW_COUNT::"ezy_Users": 1
ROW_COUNT::"tblCreditCard": 4
ROW_COUNT::"eza_Preferences": 4
ROW_COUNT::"ezr_Report List": 31
ROW_COUNT::"tblReportList": 13
ROW_COUNT::"tblShippers": 2
ROW_COUNT::"tblItems": 2
ROW_COUNT::"tblEmployeeTitles": 1
ROW_COUNT::"ezr_Report Definitions1": 1
ROW_COUNT::"tblInvoiceDetails": 2106567
ROW_COUNT::"tblProductCategory": 1
ROW_COUNT::"tblBillOfLading": 1
ROW_COUNT::"ezr_Report Definitions": 3
ROW_COUNT::"tblPODetails": 2
ROW_COUNT::"ezy_Permissions": 72
ROW_COUNT::"tblCustomers": 5203
ROW_COUNT::"tbl_Dates": 4353
ROW_COUNT::"ezr_Report List1": 31
ROW_COUNT::"tblSupplierType": 2
ROW_COUNT::"ezy_GroupUser": 1
ROW_COUNT::"tblReceipts": 5
ROW_COUNT::"tblSuppliers": 699
ROW_COUNT::"tblPOMaster": 2
ROW_COUNT::"tblTerritory": 13
ROW_COUNT::"ezy_AuditLog": 4
ROW_COUNT::"tblEmployees": 61
ROW_COUNT::"tblCompany": 1
ROW_COUNT::"tblInvoices": 140831
ROW_COUNT::"ezr_Report Print Queue": 246
ROW_COUNT::"ezy_Groups": 3
ROW_COUNT::"tblBillOfLadingDetails": 1
ROW_COUNT::"tblRelations": 12
ROW_COUNT::"tblProducts": 2765
ROW_COUNT::"tblStates": 51
ROW_COUNT::"tblPalletType": 5
FINISHED
ERROR: Determine number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 3221225477
Failed
Resuming...
Failed
请帮助我如何摆脱使用MySQL工作台从access数据库到MySQL数据库的数据转换的这些或其他替代方案。
检查表是否以正确的方式连接，例如：在我的例子中，父表中缺少唯一的id键，该键使用外键投影另一个表。因此，我检查并清除了一个表中的行，该表的引用表没有相同的条目。它对我有效。