MS Access Displays #Deleted in Every Field for Certain Tables

Anonymous
2022-01-31T20:26:19+00:00

We use an ODBC connection to bring some tables from a vendor supplied database into MS Access so that users can create their own on demand queries without needing to know SQL. Some of those tables, not all of them, have started to have problems in MS Access so that every field is populated with #Deleted when we try to open the table. We can query these tables fine using pl/sql Developer.

  • 3 tables that are working have num datatypes for primary key(s).
  • 3 tables that are not working use a combination of num and char datatypes as the primary keys. No bigint datatypes in these tables.
  • There are no pending deletes on the 3 tables that are not working.
  • Since the tables are vendor delivered, we can't change the data structure.
  • A combination of Oracle driver 12.01.00.02 or 12.02.00.01 and MS Access version 2112 build (14729.20194) - the 3 problem tables all show #Deleted in all fields.
  • A combination of Oracle driver 12.02.00.01 and MS Access version 2111 build (14701.20240) - the 3 problem tables work properly and show the data in all fields.

This seems to indicate that the problem is with the version of MS Access. I've been looking for other reports of #Deleted and what I can find are from 6 or 7 years ago and not very many are recent reports. Does anyone have an idea for a workaround? We hate to lose the ability for our users to utilize MS Access for querying these tables.

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

54 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2022-06-02T12:43:08+00:00

    "MS released the fix to the Insiders Channel yesterday and it should be available for the current channel probably later today"

    https://www.access-programmers.co.uk/forums/threads/new-access-sql-backend-bug-deleted-showing-in-tables.323388/post-1829306

    Anyone confirm or see this fix yet?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-06-02T13:03:57+00:00

    Which channel are YOU on? Have you seen it yet? Have you checked for it?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-06-02T13:20:00+00:00

    I have tried updating and do not see anything yet. I am not on the insider program either.

    Was this answer helpful?

    0 comments
  4. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-06-02T19:55:28+00:00

    Same here. I am not sure when the update will be available to everyone.

    Was this answer helpful?

    0 comments