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 Office button image , 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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.