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?


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SteveL13Author Commented:
Perfect explanation.  Thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.