Refreshing data ... OLE DB Jet Provider 
Author Message
 Refreshing data ... OLE DB Jet Provider

Nope, you must use requery to get new records.  Resync will not show newly added records as stated (copied from ADO manual) below

-Start of quotation
Use the Resync method to resynchronize records in the current Recordset with the underlying database. This is useful if you are using either a static or forward-only cursor but you want to see any changes in the underlying database.

If you set the CursorLocation property to adUseClient, Resync is only available for non-read-only Recordset objects.

Unlike the Requery method, the Resync method does not re-execute the Recordset object's underlying command; new records in the underlying database will not be visible.

- End of quotation

    Whenever I use the resync method on a recordset, it only refreshs existing and deleted records changed by other users (it doesn't matter which cursor was used, the results were always the same) ... Is there anyway to show new records added by others users without using the requery method.

    Marlon Reid

Sat, 10 Nov 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Data Environment/Jet 4.0 OLE DB Provider problem

2. Create Jet 3.5x DB with OLE DB Provider 4.0

3. OLE DB Provider for Jet 3.5x

4. Microsoft.Jet.OLEDB.4.0 OLE DB provider

5. Connection with OLE DB Jet 3.51 Provider

6. OLE DB Provider 4.0 for Jet SLOW

7. OLE DB Jet Provider 3.51 or 4.0 ?

8. Microsoft Jet 3.51 Ole Db Provider, where is?

9. JET 4.0 ole db provider

10. Jet 3.51 OLE DB Provider

11. OLE DB Provider 4.0 for Jet SLOW


Powered by phpBB® Forum Software