We are migrating to another accounting system, but still have a legacy system built in MS Access (97/2000/2003) with SQL Server as the backend.
The system running Access has to be in the same office as the database, because otherwise it runs entirely too slow.
The way we have worked around this so far is by running 2 RDP sessions on the server, and then buying additional Windows Pro licenses to run VMs that are in the same office as the server. The user will then attach via RDP.
We need to upgrade to a newer version of Windows Server. I am trying to understand what options exist that might be a better option.
We are a very small company, and already have licensed copies of MS Windows and Office on most users desktops. We only need the connection to work for about 4 remote users.
What options are available that might best fit our situation?
- It seems like getting Windows Server and Remote Desktop Services set up for multiple users would be more expensive than buying a few more copies of Windows 10 Pro.
- We are pretty open on options, but we just don't know what they are. We have even considered something like running the database across multiple locations and doing some sort of syncing, but that seems overly-complicated.
- I found some rumors of a multi-user Windows 10 coming in late 2018, but it looks like that never materialized.
- We don't even really need Windows server, we aren't using the domain, SQL Server runs fine on Windows Pro.
Thanks for any help with this, and please let me know if there are any issues with my question. I'm mostly a lurker on StackExchange site, and have rarely posted.