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
    Programmer/Analyst