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) & _
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "tblBatchPaymentLog", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
rs!NumberOfPayments = wkNumPaymentsCreated
rs!AmountOfPayments = wkTotAmountPaymentsCreated
rs!DateTimeOfBatch = thisBatchDateTime
rs!UserCreating = GimmeUserName
rs!BatchNum = thisBatchNumber
Set rs = Nothing
Is there any advantage to either technique?