Forum Discussion
Sharing and updating an ACCESS database on the cloud
MALGhalayini What I do for my office is:
I have taken real IP (Public IP) from my internet service provider. I have installed MSSQL server to one of my Windows Server computer and assign that public IP to one of network interface so that MSSQL database can be accessed via that real IP. Now I have developed front-end database objects and liked those objects to MSSQL table through linked table. Now, my users can use that database from any where from office (I have 3 different location) as well as home. Obviously I have limit access who do not need to access the database from outside of office. You may think this model or SQL database hosted in cloud.
Thanks. That's actually the method I prefer, and which I often used for clients when I was still working. The only thing I'd want to clarify is whether the term "in the cloud" means the same thing for everyone and whether this approach is what is often meant. I think you are right in that most people say "in the cloud", but really mean that they can have users located in many different places, as you described.
- A quick related question related to our previous subject :
If the user is subscribed to Microsoft Office 365 to be able to use the cloud ACCESS file, does he/she needs MS-Office to be installed on his local PC ?- Access runs ONLY on a desktop computer. It is part of most versions of MS 365, but not all. I would imagine that a business would have a version that includes it. It is installed, however, onto the local PC to run the Front End.
Dear Mr. Harun
Thank you for sharing your experience ...
I guess those employees are shooting for using ACCESS hosted on cloud server
