Run a Macro without opening a database

[paul.raeburn]

I want to run a macro without opening a database: I have a Back-end and Front-end database, I want a macro in the backend to run to collect data from a number of sources, so that data is refresh daily is there a way of achieving this, or can I create a procedure when the Front-end opens that a check is made on the data held in the Back-end if it has not been updated today to execute a refresh and display a message alert to the user that this action is taken place.

Many Thanks