Results 1 to 4 of 4
  1. #1
    JRodko is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Oct 2018
    Posts
    127

    Simple and cost effective cloud backend storage?

    Hello. Some context...

    We have a company wide "MasterDatabase" that is about 80MB in size and has several queries and forms for importing/exporting data etc.

    The database is currently shared via a file/folder sync service called DriveHQ. Each of the 4 or 5 remote users just syncs a copy of the .accdb file. Naturally, this causes a lot of headaches between file conflicts (two users opening at once) as well as accidental overwrites.

    I am looking for a simple and hopefully cost effective way to split this database, and host the back end on some sort of cloud service. I have been playing with Sharepoint but I don't fully understand what's supposed to be happening. I've also looked at MySQL but the costs are pretty tough to digest.

    The ultimate goal of course is that each of us can open our own front end copy to design queries and export data, etc. without worrying about conflicts as much. We use the data as read only about 99% of the time, and only add new data intermittently.



    Thanks

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    using the internet costs, there is nothing for free.

    do you not have a corporate network to put the BE on? VPN?

    Usually recommendations are to use terminal server or citrix if you want to access from anywhere. These also overcome the problem of connecting wirelessly and using non windows OS machines.

    You could look at using sql azure as your backend

    Your current solution is not workable, nor is one drive and similar.

  3. #3
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Agree with Ajax.

    Azure on a small scale can be pretty cheap, but it depends on what you consider expensive.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #4
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    Hello JRodko, see article and video I posted last night regarding SharePoint which works really well! I have 6 users using an Access front end on their machines at their homes pulling data from the database hosted in SharePoint.

    https://www.accessforums.net/showthread.php?t=83818

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

Similar Threads

  1. Re-Link to backend data on network attached storage
    By GraeagleBill in forum Access
    Replies: 6
    Last Post: 06-11-2018, 05:10 PM
  2. Effective way to learn VBA
    By CryLittleSister in forum Programming
    Replies: 8
    Last Post: 03-27-2017, 05:42 AM
  3. Access backend in the cloud - am I dreaming?
    By Gina Maylone in forum Access
    Replies: 5
    Last Post: 01-01-2016, 09:22 PM
  4. backend-tables in cloud, frontend on desktop
    By raffi in forum Import/Export Data
    Replies: 4
    Last Post: 12-15-2014, 11:57 AM
  5. Filter not effective
    By GraeagleBill in forum Programming
    Replies: 5
    Last Post: 04-08-2013, 02:18 PM

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