Results 1 to 5 of 5
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,080

    Backend shared "on the cloud"


    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?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    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.

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,080
    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?

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,235
    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,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 11-20-2019, 03:22 AM
  2. Simple table relationships ("faces" to "spaces" to "chairs")
    By skydivetom in forum Database Design
    Replies: 36
    Last Post: 07-20-2019, 01:49 PM
  3. Replies: 1
    Last Post: 07-16-2019, 03:09 PM
  4. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  5. Replies: 1
    Last Post: 06-27-2014, 10:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums