in

The ORM Foundation

Get the facts!

Importing Model from Access

Last post Tue, Jun 21 2022 15:08 by Ken Evans. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • Tue, Jun 14 2022 10:16

    Importing Model from Access

    I am just getting to know NORMA (having used Visio Modeler a long time ago) and so far:

    A) Installed NORMA in VS 2019 (CE) and completed the Tutorial.
    B) Imported a complex model from an SQL server (Express)DB with no errors.
    C) Had several failures trying to import Access databases running in Access 2010

    All attempts to import an Access file result in an error dialogue with the message:
    The specified invariant name is not supported"
    Connection Tests are OK.  Both mdb and .accdb formats give the same result.

  • Tue, Jun 21 2022 15:08 In reply to

    • Ken Evans
    • Top 10 Contributor
      Male
    • Joined on Sun, Nov 18 2007
    • Stickford, UK
    • Posts 802

    Re: Importing Model from Access

     The workaround for this problem is to import the Access database into SQL Server and then import the schema from SQL Server.

    Ken 

Page 1 of 1 (2 items)
© 2008-2020 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service