Welcome to ModelRight Sign in | Join | Help
in

Access problem

Last post 06-25-2008, 9:55 AM by micder. 2 replies.
Sort Posts: Previous Next
  •  06-24-2008, 11:33 AM 670

    Access problem

    Hi,

    I have installed the Model Right community edition, but I have a problem when I try to reverse an Access DB. When Model Right tries to extract the relations between the table, the following error appears:

     

    Error: load_table_relations: State: IM001; Native Error: 0; Message: [Microsoft][Driver Manager ODBC] The driver doesn't support this function


    Could anyone help me?

     

    Thanks a lot

     

    Michele 

  •  06-24-2008, 11:49 AM 671 in reply to 670

    Re: Access problem

    Unfortunately, the MS Access ODBC driver doesn't support ODBC Level 2 functions like SQLForeignKeys. That is the reason why you see the errors.

    You will need to use an off-the-shelf Access ODBC driver that is ODBC 2.0 or higher compliant.

    Hope this helps.


    ModelRight Evangelist
  •  06-25-2008, 9:55 AM 672 in reply to 671

    Re: Access problem

    Hi,

    thanks a lot for your reply. I'm searching for an ODBC driver thati is ODBC 2.0 or higher compliant, but I haven't found it. Could you please tell me where could I find it?

     
    Thanks again

     
    Michele