Access and Google Drive

Posted on 2014-08-11
Last Modified: 2014-11-12
I have no experience with MS Access on Google Drive.  How does it work?  Does it work for multiple users to get at the database?  Is it a front end/back emd situation?  Front end on the user's computer and the back end on Google drive?


Question by:SteveL13
    LVL 56

    Accepted Solution

    In general, on-line drives such as One Drive, Google, Dropbox, simply don't work with Access.

    First, Access with its default database engine (JET or ACE) were never designed to work over a WAN.   You can do it with a high end WAN on a dedicated point to point, but that doesn't describe the internet<g>.

    Second, the DB needs to reside on an OS that can place and hold locks on a file.   All these services are file sharing, but not as one would find sharing a disk locally.

    You can download a file, use it and then uploaded, but any other updates to the file in that time would be lost.


    Author Comment

    Perfect explanation.  Thanks.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    Google Forms is a great platform to easily create polls, questionnaires and surveys. The service allows you to receive data in real-time and is a simple way to conduct large-scale surveys that can be distributed to multiple people.   The platform …
    This Micro Tutorial demonstrates in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate Google Calendar to monitor updates with top sites, such as Facebook, Google, Twitter, etc. with Marketing News. Each update of Google Calendar can be monitored, correlate dips and spikes in your website traffic, …

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now