So here is the setup.
-I have a accounting database/program that was created with MS Access (Database + Forms).
-I want to be able to access this program from multiple locations over the internet.
-there will only ever be a max of 5 users/different locations connected.
-The database cannot be converted to SQL, or anything else as we didn't create the original program.
-I'm going to purchase a Windows Server to host the database, i would like to know my best west to proceed from that point?
-I've been told VPN+Access is a bad combo. so im guessing thats out the window
-How about Remote Desktop? or VDI (which im guessing would be better as this creates a Virtual Desktop for each user to connect)
thanks,
NS