Results 1 to 4 of 4
  1. #1
    beeth2022 is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2022
    Posts
    1

    Cloud services for 5MB applications

    Hello everyone, I am a private user (Win10 + Office365) who manages some Access databases of approximately 5 MB. I would like to start trying to manage them on cloud. I had thought of SQL but I had found offers (Aruba.it) that propose MySQL or Microsoft SQL Server (what differences?). Which one do you recommend the two? Given the small of my applications, only 5MB, which Free Smart Free Provider do you recommend? (I would prefer to try to play a little and then subscribe)

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    An Access FE won't work over a cloud connection with an Access BE. Well not even vaguely reliably. It relies on SMB protocol which is not WAN friendly.
    You will need a MySQL / Azure SQL / SomeOther DBMS to work with a cloud based back end.

    We use Azure SQL for majority of our clients backend data. It's not free but very reliable, and cost effective.

    I don't know of anyone that provide a free decent hosted Back end datastore. Without being rude you would have to ask why would they?
    You can get a free Developer trial of most of the systems mentioned above. That would at least get you started.

    From a developing perspective you can load SQL Server Express locally and move everything to that to see how you get on - if the bug bites then look at cloud storage based on that.
    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 ↓↓

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Which one do you recommend the two?
    for cloud based databases, mySQL is the most common offering. In terms of performance, not much between them.

    Alternatives is to use a terminal server provider or citrix. Just log in via remote desktop. Costs vary, but from a conversion perspective, virtually no cost at all. Just move your files to terminal server and relink FE/BE.

    If it is just you and you are not supporting clients, One Drive is an option - but means copying the BE to your local drive and copying it back again when done - but easy enough to automate.

  4. #4
    neenajk is offline Novice
    Windows 11 Access 2016
    Join Date
    Oct 2022
    Posts
    3
    As stated by above users MySQL is common, but there also free cloud services for SQL Server.
    MySQL is open-source database while SQL Server has free limited version but not open-source.

    You can search on google for free sql server hosting or free mysql hosting, there are lots of hosting providers which gives free hosting for both.

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

Similar Threads

  1. Updating distributed applications
    By Seamus59 in forum Programming
    Replies: 2
    Last Post: 07-09-2013, 11:15 AM
  2. Bacode Applications.
    By cap.zadi in forum Reports
    Replies: 10
    Last Post: 12-28-2011, 11:34 AM
  3. Applications.CreateControl
    By msr71 in forum Programming
    Replies: 5
    Last Post: 04-24-2011, 09:01 PM
  4. How to use one DB file in many other DB applications ?
    By cement in forum Database Design
    Replies: 4
    Last Post: 01-01-2011, 05:50 AM
  5. Killing open applications using VBA
    By zippy483 in forum Programming
    Replies: 4
    Last Post: 03-03-2010, 10:04 PM

Tags for this Thread

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