The Refresh method on a Collection object updates the objects in a collection to reflect objects available from and specific to the OLE DB provider.
collection.Refresh
None.
This method is only supported on the Fields and Properties collections under the OLE DB Provider for AS/400 and VSAM.
The Refresh method accomplishes different tasks depending on the collection object on which it is called.
Using the Refresh method on the Fields collection has no visible effect. To retrieve changes from the underlying database structure, either the Requery method must be used or, if the Recordset object does not support bookmarks, the MoveFirst method must be used.
Using the Refresh method on a Properties collection of some objects populates the collection with the dynamic properties the provider exposes. These properties provide information about features specific to the provider beyond the built-in properties ADO supports. The OLE DB Data Provider for AS/400 and VSAM does not support any provider-specific properties.