Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-370

No primary keys in Access linked tables - even if autonumber

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 3.1.16
    • N/A
    • General
    • None

    Description

      After linking tables from MariaDb Access shows absolutely no primary keys ... for any table ... even if the only key is an autonumber. Although this seems likely related to the recent varchar PK reports ... this is all of them.

      The old driver still seems to work with the latest Access client. Although last year I had to rewrite the connection strings to use OPTION instead of the parameter names (Access seems to have stopped connecting based on parameter names and only the OPTION value).

      Attachments

        1. PK TEST 1.LOG
          608 kB
          Ray Merrill
        2. tbl_colors.sql
          2 kB
          Jörg
        3. test1.sql
          2 kB
          Ray Merrill
        4. tracingtab.png
          17 kB
          Ray Merrill

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              thrunch Ray Merrill
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.