Daven Posted February 4, 2007 Share Posted February 4, 2007 I am newbie While using Migration tool for the first time a simple AESBC.MDB with 1 table T1392 I get this error - Tables `AESBC`.`T1392` --------------- A table must have at least 1 column `AESBC`.`T1392` --------------- The following error occured while transfering data from T1392 [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'T1392'. looking back at the SQL script I wander if there is something wrong here DROP TABLE IF EXISTS `AESBC`.`T1392`; CREATE TABLE `AESBC`.`T1392` ENGINE = INNODB; ??? Quote Link to comment Share on other sites More sharing options...
shoz Posted February 4, 2007 Share Posted February 4, 2007 looking back at the SQL script I wander if there is something wrong here DROP TABLE IF EXISTS `AESBC`.`T1392`; CREATE TABLE `AESBC`.`T1392` ENGINE = INNODB; ??? I'm not familiar with the migration tool but I will confirm that the generated CREATE statement is missing the column definitions Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.