Adding a Record to a table, execution time

With all else equal, same table, same network, same number of users, same machine, same operating system etc..

Access 2003 front end and Access 2003 backend, linked tables, backend is on a server, front end is on each clients local machine.  

All values to be inserted in the new record are in temp variables, not being pulled from another table or query.

I'm trying to improve the efficiency of a client application.

I have used  both of the below techniques to add a record to a table.  In your experience, are either of these two techniques of adding a record to a table is better?  Or perhaps they are the same.
I realize the two examples refer to different tables, I am interested in processing time, reducing record locking etc..  between the two formats if they were being performed on the same table with all else being the same.
'

CurrentDb.Execute " insert into tblErrorLog " & _
              "( [ErrNum], [ErrText], [ErrUser], [ErrDateTime]  )  " & _
  "   values(" & passedErrNum & _
          ", " & Chr(34) & wkFullErrDesc & Chr(34) & _
          ", " & Chr(34) & wkErrUser & Chr(34) & _
          ", " & Chr(35) & wkErrDateTime & Chr(35) & _
          ")", dbFailOnError

Select allOpen in new window

or

'
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "tblBatchPaymentLog", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
'
rs.AddNew
    '
    rs!NumberOfPayments = wkNumPaymentsCreated
    rs!AmountOfPayments = wkTotAmountPaymentsCreated
    rs!DateTimeOfBatch = thisBatchDateTime
    rs!UserCreating = GimmeUserName
    rs!BatchNum = thisBatchNumber
    '
rs.Update
'
rs.Close
Set rs = Nothing
'

Select allOpen in new window

Is there any advantage to either technique?