Automatically Refresh datasheet/tables

[akira]

Hi all,



I have an access file which connects to an ODBC database, and I want it to update at a set time interval.

I searched through the internet, and noticed that most solutions require a form and putting the requery macro in the form's events.

My file doesn't need a form, its only function is to act as a medium to store the data from ODBC and lets a BI Tool play around with it.

My question is, how do I make the access file update automatically at a timely interval (every 30 mins, 1 hr etc.). Is it necessary to create a form? Are there other ways? If so can someone walk me through the steps?

Thank you very much,
akira-

[pbaldy]

You shouldn't need to do anything. Your BI tool should get updated records whenever it queries the file. The Requery is for the user interface, not the data itself.

[akira]

Do you mean that the BI tool will run the queries within my Access file and update the data? The BI tool I am using is called Tableau.

[pbaldy]

I'm not familiar with it, but whether it queries the Access tables directly or uses Access queries, they should get current data at the time they are run. The reason you requery a form is because it would have gotten data current at the point it opened, and for whatever reason you want to requery that data to catch any changes that occurred after the form was opened.

That said, if your db is extracting (copying) data from an ODBC source and storing it separately, that process would need to be done to update the data in Access. My assumption is that is not the case though.

[akira]

Yes, right now when I changed the query within my Access file, and let the BI tool refresh, the data is still the old data, which means it is running my access queries.

Is there a way to set my Autoexec queries in access to run at a timely interval?