Forum Discussion

gil_gentien's avatar
gil_gentien
Copper Contributor
May 30, 2022

Office pro 2021 version 2205 build 15225.20204 Bug access sql linked table #delete

I have bug  with this new version , some off my linked table  (slq native client 10) diplay #delete in all colums. I have other computers with an old version they work perfectly. What can i do to s...
access
KenzoSoZy's avatar
KenzoSoZy
Copper Contributor
Jun 01, 2022
I use MySQL from Access via MySQL ODBC Driver,
after 2205 update, some of tables also display #delete.
first aid
Restore from 2205----> to 2204
open command prompt (admin mode)
(paste)
cd %ProgramFiles%\Common Files\Microsoft Shared\ClickToRun
(next line paste)
officec2rclient.exe /update user updatetoversion=16.0.15128.20248
then automatically rollback
after this
Access account info panel
office365 autoupdate----> off
until this problem is solved
LaraDutton's avatar
LaraDutton
Copper Contributor
Jun 02, 2022
this is from another thread I'm on, I can't validate as the move to ODBC 17 work as a fix for me yesterday...
""
George Hepworth replied to George Hepworth
‎Jun 01 2022 04:11 PM

The MS Access team is reporting that this is now fixed.

"This should be fixed now in Current Channel (Preview) channel now, and the fix should be in Current Channel tomorrow."

""
  • JoneSh77's avatar
    JoneSh77
    Copper Contributor
    Jun 03, 2022
    Hi
    I have updated Access today and it works fine again. The problem seems to be solved
    Thanks
    • cbgbnyc1's avatar
      cbgbnyc1
      Copper Contributor
      Jun 06, 2022

      JoneSh77  what is your version # ? thx

      • JoneSh77's avatar
        JoneSh77
        Copper Contributor
        Jun 07, 2022

        Hi,
        Sorry for the delay
        I have Microsoft Access Version 2205 Build 16.0.15225.20172 64bits version
        Since friday it works again for me with sql server and with postgresql
        Best regards

    • annz-vt's avatar
      annz-vt
      Copper Contributor
      Jun 03, 2022

      JoneSh77 

       

      Hi - thanks for the update.  Could you (or anyone else who has received the fix) post your current Office version and channel?  It still hasn't shown up for me.

       

      Thanks.

      • isladogs's avatar
        isladogs
        MVP
        Jun 03, 2022
        For info, MS have just announced that the #Deleted bug fix is now available to all in the Current Channel, Current Channel (Preview), Beta, and Semi-Annual Channel (Preview).
        It does not require a new build but will require closing and restarting Access to see the change. In other words, the fix was done by rolling back the change that caused the problem

        Just tested & now working for me

Resources