Hi to everyone.

Has anyone had any success in updating a disconnected recordset in the
following manner?

.
.
.

Set rsCustomers.ActiveConnection = GetADOConnection		' Gets an active
connection for the disconnected recordset

rsCustomers.Filter = adFilterPendingRecords	' This statement should filter
records that have changed
                        '  but have not yet been sent to the server
(updated)

rsCustomers.UpdateBatch adAffectGroup	' This statement updates records that
satisfy the previous filter setting

.
.

The peculiarity I am experiencing is that changed records are actually being
updated by the "rsCustomers.Filter = adFilterPendingRecords" statement. The
"rsCustomers.UpdateBatch adAffectGroup" statement seems superfluous. If I
skip over the statement in debug mode, the expected updates occur. My
problem is, they shouldn't.

I am using MDAC 2.7. Has anyone any explanations or experience of the above?

James