HELP - From Access 2007 (.accdb) to MySQL
Posted by: Francesco Murphy
Date: April 12, 2012 08:43AM

hi everyone
I'm trying to convert my access database to a mysql database. When I lunch the migration toolkit, after the db connection, in the reverse engineering page it shows this error message:

---------------------------------------------------
Initializing JDBC driver ...
Driver class MS Access
Opening connection ...
Connection jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Users\antonacci\Documents\prova_database.accdb;DriverID=22;READONLY=true;UID=;PWD=}
The schema could not be reverse engineered (error: 0).
ReverseEngineeringAccess.reverseEngineer :[Microsoft][Driver ODBC Microsoft Access] Impossibile aprire il database "(sconosciuto)". È possibile che il database non sia riconoscibile dall'applicazione oppure che il file sia danneggiato.
Details:
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringAccess.reverseEngineer(ReverseEngineeringAccess.java:92)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
------------------------------------------
I think it's because the READONLY has TRUE value, but how can I change it because in the Access 2007 I can't modify the authorization setting in this access version

Can any one help me please?

Thank you



Edited 1 time(s). Last edit at 04/13/2012 02:35AM by Francesco Murphy.

Options: ReplyQuote


Subject
Written By
Posted
HELP - From Access 2007 (.accdb) to MySQL
April 12, 2012 08:43AM


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.