I use this code to update a sql server table MS Access VBA 2003 code:
strSQLDelete = "DELETE FROM dbo.tbl_PS_DiscrepanciesLevel123Tmp"
Set conn = New ADODB.Connection
conn.Open g_str_BSQLP01VW_HostMR_Connect (this a string constant)
It works fine. Is there a way to make sure the update is committed, or does that require using a stored procedure