Microsoft Jet and Replication Objects
Forces any pending writes to .mdb files, and refreshes memory with the most current data from the .mdb file.
Syntax
JetEngine.RefreshCache(Connection)
Parameters
Connection The ADO Connection object for which to refresh the cache. An error will occur if the connection is not a valid, open ADO Connection. An error will occur if the provider used to create the connection does not support the RefreshCache method.
Remarks
You don't need to use this method in single-user environments unless multiple connections are made to the database. The RefreshCache method may increase performance in a multiuser environment because it forces the database engine to write data to disk, releasing locks on memory.