I've automated some old access files at work. (What previously was clicking a button in a form, waiting an hour, repeat 4 times, is now running it all one go on open, then closing and compacting the database).
The files are stored on a shared drive that is locally on the server that we try to run them on.
I can run the files on my PC, both while on the network and through VPN. I cannot, however, run them on the server. When i open them, access starts up and shows the getting started-view and nothing happens.
When running them through a scheduled task, as intended (they take a few hours, so the idea is to run them during the night on the server), I just end up with a locked access file and a process with no GUI for access that further hinders removal of the lock file. After a weekend, I have 9 processes and all the files have locks and nothing is run.
The weird part is that I get no error messages. Furthermore, just a few weeks ago, when I was building them, I could run them, but they'd only perform half of the VBA scripts (it's exporting a couple of CSVs for example, and they didn't generate new ones, when run on the server, but keep working fine from my PC). Then, after a week off from work, the above stated behavior began instead.
At this point, I've probably spent a whole work week troubleshooting this and gotten nowhere. Any help is appreciated. Haven't found anything from google searches that matches this behavior...
In a strange tun of events, it appears to be working now. Found that Office hadn't installed all updates. Did that and it began to work....