All my backend sharing experience has been limited to an NAS connected to a LAN. In such arrangements, JET takes care of the issues of simultaneous use, what about if the backend is installed on a cloud storage?
All my backend sharing experience has been limited to an NAS connected to a LAN. In such arrangements, JET takes care of the issues of simultaneous use, what about if the backend is installed on a cloud storage?
Fairly common topic.
https://regroove.ca/blog/how-to-move...%20your%20data
Maybe use Azure?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Not sure how your reply maps to a split DB where ONLY the backend tables would be on the cloud. Are multi-use accesses delt with properly by Access?
It is not going to work, "cloud" shared drives are not meant for that, see here (and many more threads on this subject):
https://www.access-programmers.co.uk...edrive.316796/
Cheers,
Investigate using an azure backend or using terminal server or Citrix to host both front and backend. The latter will give better performance and minimal changes to the front end (basically relinking) and has the potential benefit that non windows devices can also use the app (the OS needs to support Remote Desktop)
But all come at a cost so you need to decide your budget, nothing web based is truly free