marco to run without logging onto server

is there a way to write access macros to where the server doesn’t have to be logged into all the time.