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; ??? Link to comment https://forums.phpfreaks.com/topic/36978-access-migration-error/ 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 Link to comment https://forums.phpfreaks.com/topic/36978-access-migration-error/#findComment-176481 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.