I understand that we need to make the connection to the database adLockOptmistic before we can modify any data in the database. If we were not using pure SQL execution, the code would be:

Set rstCustomers = New Recordset
rstCustomers.Open strSQL, conDatabase, _
adOpenDynamic, adLockOptimistic

But if we use the pure SQL string (without opening a recordset), what would be the code? Where do we put the adLockOptmistic?