We were using MSACESS in our application before and our application used Multiple recordset from the same table. Recordset Refresh interval in MSACESS is 5 seconds. So we did not have problem with the multiple recordset getting other recordset changes.

Now we migrate to SQL server , we are opening recordsets as adDynamicSet and it is not reflecting the changes happening in the table. What is the default recordset refresh interval in sql server ado provider and is their any method to force the refresh in ADO. Anyone knows answer for this issue????/