Access on the cloud?
Hello! I am new to learning Access and have a question about remote use. The small business I work for is interested in developing a practice management database using Access. We have about 20 employees, many who work remotely in other states. I'm seeing some mixed information on the internet, so I'm coming to the pros. Our concern is to make this database easily accessible for our employees, without slow runtimes, lost data, etc.. We would love for it to be cloud-based, but have a VPN our employees currently use to access company files. I've seen some people who run the frontend on Access and host the backend on MySQL. Some seem to prefer VPN. Some say Access isn't really well-suited to remote use. What is the best way--is it even realistic--to use Access as a database for a mostly-remote organization? If we're going to do this we want to ensure I'm learning what will be most beneficial, whether that's access or SQL/PHP, or something else altogether. Thank you for your help!