• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6125
  • Last Modified:

Access and Google Drive

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?


1 Solution
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.

SteveL13Author Commented:
Perfect explanation.  Thanks.

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now