One of the best ways to improve performance in a distributed application is to avoid sending unchanged data back to the server for updating. I use the following strategy to determine if a disconnected recordset needs to be sent back to the server. Declare module level string and Boolean variables:
Private sRecord as StringPrivate bDirty as Boolean
When you first land on a new record, read it into the variable by calling SetRecord rsMyRecordset. SetRecord reads only the current record as shown:
Private Function SetRecord(rs As ADODB.Recordset) As Boolean ' Saves entire record as a single value for later comparison Dim i As Integer sRecord =
