Access How to refresh the Access database automatically???

[Amy Gao]

I import raw data in txt file to Access file to creat a database, then I use excel to creat a pivot table using the access database.

The question :
1, how to refresh the access database when the data in txt is updated?
2, how to refresh the pivot table in excel after the database is refreshed?

Urgently need ur kind & great help~
Thanks~


Amy Gao

 

[krgrajeev]

To refresh the data in a form, you could create a button on the form and attach the following code to the On_Click event:

Private Sub Command1_Click()

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

End Sub

In this example, we've created a button called Command1. When the button is clicked, the form will requery the data displayed in the form. If the data has changed, these changes will now be displayed in the form.