problem migrating from access to mysql

[Giorgos Louloudis via AccessMonster.com]

Hello everyone,
Well i have a problem migrating an mbd file to mysql with the migration
toolkit.I have used migration toolkit for migrating an access file but this
one is different than the old one i succeded. First of all,for this data2007.
mbd file i have created an mdw so as to be able to have users and passwords
in my database. I stopped admin from having the administration and created
another administrtor called George (George has a password of course).He is
the owner of all objects (except system objects).Finally, this data2007.mdb
file is the result of a splitting of the primary mdb file to front end and
backend. To be more precise data2007.mdb is the backend (the actual data).
Now the problem is that when i use the migration toolkit of mysql i select
the mdb file (data2007.mdb) that i want to migrate and i set the username :
George and password:9619388 in the dialog boxes.The toolkit sees correctly
the schema but as i select it and press next, at the reverse engineering step
i get this error:

Initializing JDBC driver ...
Driver class MS Access
Opening connection ...
Connection jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=C:\
Documents and Settings\George\My Documents\Facadoro\data2007.
mdb;DriverID=22;READONLY=true;UID=George;PWD=9619388}
The schema could not be reverse engineered (error: 0).
ReverseEngineeringAccess.reverseEngineer :[Microsoft][ODBC Microsoft Access
Driver] You do not have the necessary permissions to use the '(unknown)'
object. Have your system administrator or the person who created this object
establish the appropriate permissions for you.
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(Unknown
Source)
com.mysql.grt.modules.ReverseEngineeringAccess.reverseEngineer(Unknown Source)

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 can not figure out what is the real problem!!If anyone could help please
reply to my post!!!
Thanks in advance!!

 

[Chris Mills]

I am surprised if there is a satisfactory converter from Access to anything
(for example, Access to Visual Basic converters reportedly only partially
work)

Nevertheless, your issue seems to be security. I'd de-secure the Access
database before attempting to convert it to something else. Otherwise your
problem sounds likely to me!

See here for the SecFAQ and some info on desecuring a database:
http://support.microsoft.com/kb/165009

Although you can probably convert a secure database, I reckon it's just easier
to remove security beforehand!

Chris

Hello everyone,
Well i have a problem migrating an mbd file to mysql with the migration
toolkit.I have used migration toolkit for migrating an access file but this
one is different than the old one i succeded. First of all,for this data2007.
mbd file i have created an mdw so as to be able to have users and passwords
in my database. I stopped admin from having the administration and created
another administrtor called George (George has a password of course).He is
the owner of all objects (except system objects).Finally, this data2007.mdb
file is the result of a splitting of the primary mdb file to front end and
backend. To be more precise data2007.mdb is the backend (the actual data).
Now the problem is that when i use the migration toolkit of mysql i select
the mdb file (data2007.mdb) that i want to migrate and i set the username :
George and password:9619388 in the dialog boxes.The toolkit sees correctly
the schema but as i select it and press next, at the reverse engineering step
i get this error:

Initializing JDBC driver ...
Driver class MS Access
Opening connection ...
Connection jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=C:\
Documents and Settings\George\My Documents\Facadoro\data2007.
mdb;DriverID=22;READONLY=true;UID=George;PWD=9619388}
The schema could not be reverse engineered (error: 0).
ReverseEngineeringAccess.reverseEngineer :[Microsoft][ODBC Microsoft Access
Driver] You do not have the necessary permissions to use the '(unknown)'
object. Have your system administrator or the person who created this object
establish the appropriate permissions for you.
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(Unknown
Source)
com.mysql.grt.modules.ReverseEngineeringAccess.reverseEngineer(Unknown Source)

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 can not figure out what is the real problem!!If anyone could help please
reply to my post!!!
Thanks in advance!!

 

[Giorgos Louloudis via AccessMonster.com]

Dear Chris,
I would like to thank you for your advice. I thought of that as the user
thing seems to be the problem but although i want to migrate my access back
end (the tables) to mysql, i also would like to keep the front end from
access. You think that there will be no problem if the front end continues to
have the user entities?
Thanks for your time spenting to read this message!
Giorgos

I am surprised if there is a satisfactory converter from Access to anything
(for example, Access to Visual Basic converters reportedly only partially
work)

Nevertheless, your issue seems to be security. I'd de-secure the Access
database before attempting to convert it to something else. Otherwise your
problem sounds likely to me!

See here for the SecFAQ and some info on desecuring a database:
http://support.microsoft.com/kb/165009

Although you can probably convert a secure database, I reckon it's just easier
to remove security beforehand!

Chris

Hello everyone,
Well i have a problem migrating an mbd file to mysql with the migration

[quoted text clipped - 44 lines]

reply to my post!!!
Thanks in advance!!

 

[Chris Mills]

I was thinking of "program converters", there should be no real trouble with
"data converters" except for the pesky security issues.

One of my Access programs had the back end converted to MySQL (though someone
else did it), with the front end just re-linked to the MySQL tables, and there
was no trouble that I'm aware of.

(When I took it over again, I converted it back to Access <heh-heh>)

Chris

 

[Tom Wickerath MDB]

if mySql is too hard then you should use Accessz Data Projects

it is a lot lot lot simpler

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

if mySql is too hard then you should use Accessz Data Projects

it is a lot lot lot simpler

Hello everyone,
Well i have a problem migrating an mbd file to mysql with the migration
toolkit.I have used migration toolkit for migrating an access file but
this
one is different than the old one i succeded. First of all,for this
data2007.
mbd file i have created an mdw so as to be able to have users and
passwords
in my database. I stopped admin from having the administration and
created
another administrtor called George (George has a password of course).He
is
the owner of all objects (except system objects).Finally, this
data2007.mdb
file is the result of a splitting of the primary mdb file to front end
and
backend. To be more precise data2007.mdb is the backend (the actual
data).
Now the problem is that when i use the migration toolkit of mysql i
select
the mdb file (data2007.mdb) that i want to migrate and i set the username
:
George and password:9619388 in the dialog boxes.The toolkit sees
correctly
the schema but as i select it and press next, at the reverse engineering
step
i get this error:

Initializing JDBC driver ...
Driver class MS Access
Opening connection ...
Connection jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=C:\
Documents and Settings\George\My Documents\Facadoro\data2007.
mdb;DriverID=22;READONLY=true;UID=George;PWD=9619388}
The schema could not be reverse engineered (error: 0).
ReverseEngineeringAccess.reverseEngineer :[Microsoft][ODBC Microsoft
Access
Driver] You do not have the necessary permissions to use the '(unknown)'
object. Have your system administrator or the person who created this
object
establish the appropriate permissions for you.
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(Unknown
Source)
com.mysql.grt.modules.ReverseEngineeringAccess.reverseEngineer(Unknown
Source)

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 can not figure out what is the real problem!!If anyone could help
please
reply to my post!!!
Thanks in advance!!

 

[Tony Wickernark]

Access MDB _IS_ a toy, kid


SQL Server rocks; Access Data Projects is an enterprise-level development
platform.

MDB is for crybabies and retards that don't have the mental capacity to
learn a server database