I have a stand alone PC that is connected to the local network. I have an access database that I use for running some update tasks over night. Basically I open the database, set a time for a form onTimer event to trigger and leave it running. Then I lock the desktop and it will run every night no problem.
Sometimes I connect the to local PC from my laptop via Remote Desktop. I’d do what I needed to and disconnected. And the database would continue to run after a disconnected.
Now for some reason if I connect to the local pc using Remote Desktop, when I disconnect it stops the database from running! If I log back in using Remote Desktop at some point later the code in my database will start again and ‘catch up’ from the point I disconnected. But as soon as I disconnect all stops!
What’s changed!!
The only way I get this to run every night is to log into the local pc, set the database running and lock the screen. I can no longer Remote Desktop as it kills everything when I disconnect.
Can someone help please?
Sometimes I connect the to local PC from my laptop via Remote Desktop. I’d do what I needed to and disconnected. And the database would continue to run after a disconnected.
Now for some reason if I connect to the local pc using Remote Desktop, when I disconnect it stops the database from running! If I log back in using Remote Desktop at some point later the code in my database will start again and ‘catch up’ from the point I disconnected. But as soon as I disconnect all stops!
What’s changed!!
The only way I get this to run every night is to log into the local pc, set the database running and lock the screen. I can no longer Remote Desktop as it kills everything when I disconnect.
Can someone help please?