Results 1 to 3 of 3
  1. #1
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001

    Exclamation New Access / SQL bug - #Deleted showing in tables

    See here
    https://www.access-programmers.co.uk...tables.323388/

    And here


    https://answers.microsoft.com/en-us/...2504d3c?page=3

    Appears to be caused by a non-numeric primary key in the latest Access version 2205
    Version 2204 appears unaffected.

    Edit: And apparently is fixed if you use the version 17 of SQL ODBC Driver.
    The fault appears if you are using an earlier ODBC driver.
    Last edited by Minty; 05-26-2022 at 09:54 AM.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you refresh, the deletes will vanish

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by ranman256 View Post
    if you refresh, the deletes will vanish
    No. This is a new Access bug and refreshing has no effect
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-27-2017, 07:40 AM
  2. Replies: 0
    Last Post: 05-06-2017, 01:27 AM
  3. Replies: 5
    Last Post: 02-23-2014, 10:50 PM
  4. Replies: 3
    Last Post: 10-19-2013, 08:23 PM
  5. delete query produce #deleted in all deleted values
    By learning_graccess in forum Queries
    Replies: 2
    Last Post: 03-31-2012, 07:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums