Forum Discussion

pradya's avatar
pradya
Copper Contributor
Apr 30, 2025

Very slow and crash For ADODB in version 2503

When I use (Provider=Microsoft.ACE.OLEDB.12.0) for select data by command ( select ,update) in vba macro it take time so long and crash in version 2503 but can work normally in the old veriso...
community
developer
excel
Macros and VBA
office 365
Kidd_Ip's avatar
Kidd_Ip
MVP
May 06, 2025

How about trying to switch to Microsoft.ACE.OLEDB.15.0 or adjusting their connection string.

  • pradya's avatar
    pradya
    Copper Contributor
    May 07, 2025

    Install Microsoft Access 2013 Runtime first and then use  Microsoft.ACE.OLEDB.15.0

     

    Its Workkk!!!

     

    Thank you very muchhh.

     

    You save my life.

Resources