I have setup RemoteDesktop Services on a Windows 2012r2 server to allow remote users to run Microsoft Access Databases. It was working pretty good with the occasional "Your network access was interrupted. To continue close the database, and then open it again" error.
Lately I have been getting lots of locked files mostly Microsoft Access and one unrelated application.
I am tied into the corporate licensing so I have enough licenses but is there a limit to the number of users on the server who can have the same application open. (Microsoft Access being the most common issue).
I have monitoring setup and there is no network connection issue, I am not close to maxing out bandwidth, CPU or Memory.
This is quickly becoming an important issue.
I know the recommended solution is to split the Databases so that there is a front and back end but there are to many databases and I only need to keep this going for another 3-4 weeks. Does anyone have any suggestions