Results 1 to 6 of 6
  1. #1
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    Smile Access backend in the cloud - am I dreaming?

    Could it be this easy? So I have an iCloud account, it is set up on my desktop and my laptop. I can get to it through Windows Explorer. So for giggles, I split my database and put the backend on my iCloud drive, linked it up, and am currently sharing the data between desktop and laptop.

    I have researched Access in the cloud and have found numerous complicated solutions. What I've done seems too good to be true. But so far as long as I have WIFI or my cellular connection, I'm golden.

    Looking for someone to shoot holes in this for me.



    Happy New Year!
    Gina

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    The only issue that I am aware of is managing the loss of connections. So you would have to use unbound forms and code that made a connection for each CRUD operation. Error trapping and rolling back failed sql actions become more important. Also, orphaned locking files are an issue. If you have multiple users, the locking files become a larger issue.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Hi Gina,

    You might want to read this article by Albert D. Kallal about Access over a WAN.

    Using a wan with ms-access? How fast, how far?
    http://www.kallal.ca/Wan/Wans.html

    (main site is http://www.kallal.ca/)

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    From another group I participate in: RE Wifi network

    A connection may work fine, but multiple users or powerful neighborhood networks (or other noise sources) can abruptly cut off the connection. That can corrupt the database file if you are writing to it at the time. This type of interference isn't a problem if users are mostly reading from the database.


    A WAN connection that covers any connection from a local system to a server via the Internet can cause trouble. Reading the database may be slow but acceptable. However, writing to the database is error prone and can cause corruption. When bottlenecked traffic interrupts data transfer, Access times out, believing the connection has been lost. This behavior usually leaves the backend database in a corrupted state.

  5. #5
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Thanks Steve, good read. Happy New Year!! :-)

  6. #6
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Thanks ItsMe! Happy New Year!

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

Similar Threads

  1. Cloud based Access?
    By Perceptus in forum Access
    Replies: 4
    Last Post: 12-30-2015, 05:05 PM
  2. Replies: 1
    Last Post: 11-02-2015, 03:28 PM
  3. backend-tables in cloud, frontend on desktop
    By raffi in forum Import/Export Data
    Replies: 4
    Last Post: 12-15-2014, 11:57 AM
  4. Using Cloud?
    By DaveWms in forum Access
    Replies: 2
    Last Post: 12-11-2014, 08:39 AM
  5. Replies: 3
    Last Post: 01-02-2014, 08:11 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