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 1 reply thread
  • Author
    Posts
    • 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 1 reply thread
  • You must be logged in to reply to this topic.