paulmcneil
asked on
Commit a SQL Server connection update
I use this code to update a sql server table MS Access VBA 2003 code:
strSQLDelete = "DELETE FROM dbo.tbl_PS_DiscrepanciesLe vel123Tmp"
Set conn = New ADODB.Connection
conn.Open g_str_BSQLP01VW_HostMR_Con nect (this a string constant)
conn.Execute strSQLDelete
It works fine. Is there a way to make sure the update is committed, or does that require using a stored procedure
strSQLDelete = "DELETE FROM dbo.tbl_PS_DiscrepanciesLe
Set conn = New ADODB.Connection
conn.Open g_str_BSQLP01VW_HostMR_Con
conn.Execute strSQLDelete
It works fine. Is there a way to make sure the update is committed, or does that require using a stored procedure
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.