
Dynamic ADO Recordset Not Dynamic (Does Not Refresh Data)
I have a problem where a dynamic ADO recordset in my VB6 app does not
refresh as I expect it to.
If I have two instances of my program running (let's say on separate
machines), and a user updates a record, the other user does not see the
changes unless the recordset on the second machine is closed and reopened.
The code to open the recordset is as follows:
Set rsClient = New ADODB.Recordset
rsClient.Open "Client", cnFIS, adOpenDynamic, adLockOptimistic
This is an ADO recordset in VB6 running against an SQL Server 2000 database.
I had to use a client-side cursor in this case, since I make extensive use
out of the Sort and Filter recordset methods.
Isn't a dynamic recordset supposed to refetch record data every time that
the current record changes? How come that is not happening in this case?
Any help would be greatly appreciated.
Thanks,
Jack