MySQL Forums
Forum List  »  Microsoft Access

MS ACCESS to MYSQL schemata selection empty
Posted by: Scott Bing
Date: August 13, 2013 02:23PM

I am attempting to use the MYSQL Workbench Version 5.2.47 to migrate an MS Access database 2007 (file extension *.accdb) to MYSQL. The ‘Fetch Schemata List’ step completes successfully reporting no errors. Each substep (Connect to Source DBMS, Check Target DBMS Connection, and Retrieve Schema List from Source) completes successfully with a blue check mark. Here’s is the complete listing of this step:

Starting...
Connect to source DBMS...
- Connecting to source...
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Connecting to Mysql@localhost:3306...
Connecting to Mysql@localhost:3306...
Connected
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
- Fetching catalog names...
- Fetching schema names...
- Fetching schema names from C:\Temp\TestDB.accdb...
- Finished
Retrieve schema list from source finished
Finished performing tasks.

However when I click next to process the ‘Schemata Selection Screen’, it is empty. All I get is the first line with the ODBC directory displayed and the second line with the following text : accdb.None. That’s it… It does not display the schema objects of the database even though it claims to have processed them successfully in the previous step.

Options: ReplyQuote


Subject
Views
Written By
Posted
MS ACCESS to MYSQL schemata selection empty
935
August 13, 2013 02:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.