Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Ms Access Import Can Not Read

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Ms Access Import Can Not Read

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • July 7, 2011 at 2:48 am #12377
      br8kwall
      Member

      Win 7 64-bit, Office 2010 32-bit (with MS Access engine 32-bit installed). 2003 Access .MDB file. Running SQLYog 9.1 as administrator

      I just need to get the data and tables into MySQL for analysis. But I get “ODBC source did not return data for selected table” when using Access direct method in SQLyog.

      and something about “No read definition permissions” when using an ODBC source I created. Please help!

    • July 7, 2011 at 7:55 am #32399
      ashwin
      Member

      Hi,

      SQLyog's Import External Data requires access to the system tables of the Microsoft Access database for the purpose of reverse-engineering. By default, read access to the system tables of an Access database is restricted for external applications. The procedure to enable the read access depends on the MS-Office/Access version. But in every case you must first un-hide the system tables and next change some of their properties. This procedure is explained here: http://www.webyog.com/en/whitepapers/Preparing_Access__Migration.pdf

      Please follow the steps as mentioned in the above Preparing_Access__Migration.pdf file and you will be able to import properly.

      Thanks and Regards,

      Ashwin A

    • July 7, 2011 at 9:39 am #32400
      peterlaursen
      Participant

      I am not sure that the problem Ashwin refers to is the case here.

      I found this: http://bytes.com/topic/access/answers/755036-access-2003-could-not-read-definitions-no-read-definitions

      .. and it seems renaming the table sovle the problem

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.