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

MS Access shows record with AUTO_INCREMENT primary key as #Deleted after insert that does not specify that field value

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.2.6, 3.1.22
    • General
    • None

    Description

      If the value for auto_increment field is specified - all is good. And all is good if re-open the table.
      This may belong to later Access versions(observed in 2019) as I was kinda sure this works. The reason is that Access reads the newly inserted row with the query "WHERE `pkField` IS NULL, and that obviously does not work

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            Lawrin Lawrin Novitsky
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.