Jump to content

Access migration error


Daven

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.