This is in relation to post http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26862671.html
Currently I'm leaving an active signon running on my server. A task opens my secure databases at a scheduled time each day or week and runs a macro that calls a VBA function, which sends out status notifications via outlook.
Is it possible to run this macro/code without an active signon on my server. I'd like to remain logged off without access running in the background until the task starts. If not possible in access, is this possible in SQL? thanks