Auto Running a Query

[AJOLSON]

I have a table that is linked to an external file that auto populates when a
change is made to the file. Once the table is updated, I apply some business
rules to it via a query then append the changes to a Master table.

What I would like to have happen is once or twice a day is have the query
with all the business rules update the master table, automatically. As
it stands now I have to click a command button to make that happen. Is
there any way to have a query run periodically via a macro or VBA?

Thanks any help on this issue will be greatly appreciated.

Andy

 

[AJOLSON]

Thanks I give that a try

You could use the Windows Task Scheduler to open your Access application at
prescheduled times. The Access application would need an Autoexec macro to
run your query.

Steve