ADODB Object
 
Syntax
 
MarshalOptionsEnum = recordsetobject.MarshalOptions
recordsetobject.MarshalOptions = MarshalOptionsEnum
 
Description
Sets or returns a MarshalOptionEnum value that specifies which records are to betransferred (marshaled) back to the server.
 
The MarshalOptions property sets or returns one of the MarshalOptionsEnum constants that dictates whether all or just the modified records will be marshaled (transferred) from the client to the server. The default is to marshal all.
 
 
MarshalOptionsEnum Constants 
 
Constant
Value
Description
adMarshallAll
0
Returns all records to the server
adMarshallModifiedOnly
1
Return only modified records to the server
See Also
Example
 
If objRecordset.MarshalOptions = adMarshallModifiedOnly Then
   objRecordset.Update
   MsgBox "Only Modified Records Were Returned to Server", vbOK
Else
   objRecordset.Update
   MsgBox "All Records Were Returned to Server", vbOK
End If
 
Explanation:
 
In this example, only the first five records are returned even though the query string selects all records in the table.