Change how often data is updated automatically in an Access database in Datasheet or Form view

Change how often data is updated automatically in an Access database in Datasheet or Form view

  1. Open a table, query, or form in Datasheet view, or a form in Form view.

  2. Click Options on the Tools menu.

  3. Click the Advanced tab.

  4. In the Refresh Interval box, type the number of seconds you want between each automatic update of data. For example, if you type 120, the data is updated every 2 minutes.

Note   This setting takes effect only if the database is shared on a network. It updates only data that already exists in your datasheet or form. It doesn't reorder records, display new records, or remove deleted records and records that no longer meet specified criteria. To perform those actions, requery the records by pressing SHIFT+F9.