Hello, i am stuck in a little issue.

I have created an Excel file connect to an access database. In this spreadsheet i sent SQL (Inserts and Updates) via vba ADODB.Connectionthen after it finishes i would like to update the connections and the table to have the data added returned.

My problem, sometimes excel update the table and sometimes not via vba. (but if I try it manually to refresh it works perfectly) .. i already tryied several ways and nothing seems to work, bellow some attempts i already tryied but withou success:

-deactivated update in second plane
-Range("MyTable").ListObject.QueryTable.Refresh BackgroundQuery:=False
-ActiveWorkbook.Connections("Myconnection").refresh
-Application.SendKeys "%^{F5} (I tried to use wait before it , but it get slows and still fails sometime)

Bellow the connection i am using:
Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\VXB330\Desktop\Saldos.accdb;Mode=Read;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False