Refresh a datasheet

If you are sharing a database over a network, other users could be changing data while you are viewing the same data in a datasheet. Microsoft Office Access updates the data that you see at specific intervals. However, you can immediately display the most current data by refreshing the records.

Refreshing records only updates the data that is already in your datasheet. It does not reorder records, display new records, or remove deleted records and records that no longer meet specified criteria. To perform those tasks, you can requery the records.

1. To refresh data, open the table in Datasheet view.

2. On the Home tab, in the Records group, click the arrow under Refresh, and then do one of the following:

   • To refresh only the visible records on the datasheet, click Refresh.

   • To refresh all the records in the datasheet, click Refresh All.

Note: Access remembers your last action during a session and displays either the Refresh button or the Refresh All button, depending on which of the actions you last performed.

You can also specify the interval at which Access refreshes data. By default, Access refreshes data every 60 seconds.

1. Click the Microsoft Office Button , and then click Access Options.

2. In the left pane of the Access Options dialog box, click Advanced.

3. In the right pane, under Advanced, enter a value in the Refresh interval (sec) box.

Top of Page