Forum Discussion

pradya's avatar
pradya
Copper Contributor
Apr 30, 2025

Very slow and crash For ADODB in version 2503

For connection stringFor example Command

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 verison (2502 or older) and 2016,2019
 in my company we have to change from 2016,2019  to 365 all of company and affected for me 

help me Please

2 Replies

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

    • pradya's avatar
      pradya
      Copper Contributor

      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