Another important consideration when working with remote data is whether your copy of the data is up-to-date. Before you attempt to insert, update, or delete records on the remote database server, you should make sure that your copy of the data is current.
Although you can create a new Recordset object to capture the most recent data, there is a much faster method. Use the Requery method of the Recordset object to refresh the data. This method works with snapshot- and dynaset-type Recordset objects. You can use this method as a first step before an insert or update operation or any time you suspect the remote data may have changed.