<div>
It really can't. &nbsp;You can't make Access into a background app (a system service). &nbsp;Access (and Office) are foreground applications, and they expect a desktop and other things to be in place, which you only get with a login. Jim.
</div>

<div>
DO you think this is a workaround? <a href="https://expert-advice.org/windows-server/how-to-set-up-auto-login-windows-server-2012-and-2016/" rel="ugc">https://expert-advice.org/windows-server/how-to-set-up-auto-login-windows-server-2012-and-2016/</a>
</div>

Service Manager

<div>
I once used a Server 2016 Essentials which opened Outlook 2013 at system startup. &nbsp;This eliminated the need for MS Exchange. It ran bunches of background tasks, some of which ran every two minutes and some once a day. &nbsp;Some of the background tasks were completely unrelated to email. For instance,at midnight vbaproject.otm would use CreateObject("Access.Application") to start Access,, run a background program that manipulated Access then closed Access. Super powerful so worth the complexity One of the biggest problems was error handling. &nbsp;For instance, msgbox had to be avoided because it suspends all threads and waits for a response. Since nobody is watching the server console, nobody ever responds to the msgbox. Hope this helps. &nbsp; <pre><code class="code-10 nolinks" id="code-20-43281559-1">Declare Function SetTimer Lib "user32" (ByVal hwnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerfunc As Long) As Long
Declare Function KillTimer Lib "user32" (ByVal hwnd As Long, ByVal nIDEvent As Long) As Long
.... bunch of related stuff ...

Public Sub ActivateYmailTimer(ByVal nSeconds As Long) ' 

&nbsp; &nbsp; nSeconds = nSeconds * 1000 &nbsp;'The api SetTimer call accepts milliseconds, so convert to Seconds
&nbsp; &nbsp; If pubYmailTimerId &lt;&gt; 0 Then Call DeactivateYmailTimer ' deactivate previous timer
&nbsp; &nbsp; 
&nbsp; &nbsp; pubYmailTimerId = SetTimer(0, 0, nSeconds, AddressOf TriggerYmailTimer) ' activate this timer


Private Sub TriggerYmailTimer(ByVal hwnd As Long, ByVal uMsg As Long, ByVal idevent As Long, ByVal Systime As Long)

&nbsp; Call ImportThenCloseDatabases
&nbsp; Call ActivateYmailTimer(ImportClientThrottle20SecondsAtATime)

</code></pre>&nbsp; &nbsp; &nbsp; &nbsp;
</div>

<div>
I have another idea that might be simpler than the Outlook 2013 settimer approach I previously posted. If you already have an access vba program and you want to run it once a day on your windows server you can use taskmgr. I have to leave in 5 minutes, so I don't have time to explain many details. At a minimum you would need MS Access installed on your server. (Several links tell me this will work fine.) At the highest level &nbsp;taskmgr could kick off a vbscript program that &nbsp;uses CreateObject("Access.Application") to open you .accdb file and manipulate it. A third idea: If you just want to email some simple query results once a day, the ENTIRE program might be done in vbscript without ever installing Access. It depends on how "simple" the query is. &nbsp; &nbsp; Let me know if you want help with either of my three ideas.
</div>

<div>
You can run Access from task scheduler adding startup macro parameter 
&quot;C:\Program Files\Microsoft Office\Office16\MSAccess.exe&quot; &quot;D:\Database\test.accdb&quot; /x &quot;MacroName&quot;) 
MacroName is name of sub in your datatbase. Make actions and quit from Access at the end of sub (Docmd.Quit)
</div>

<div>
<div class="content wysiwyg-content fr-view">
I have an access file with VBA. I have schedules tasks to run a macro/VBA to send emails based on the query. Now the problem is it is not working when the server is logged out or when the server is restarted. How we can run the VBA codes even if the user is not logged in?
</div>
</div>


I have an access file with VBA.
I have schedules tasks to run a macro/VBA to send emails based on the query.
Now the problem is it is not working when the server is logged out or when the server is restarted.
How we can run the VBA codes even if the user is not logged in?

Run VBA in background

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.