Will the multi-user concurrency control features of Access work properly if I put an Access database on Google Drive and allow multiple users to use the database concurrently? Thanks.
Advanced Beginner
Windows 10 
Access 2013 64bit
Will the multi-user concurrency control features of Access work properly if I put an Access database on Google Drive and allow multiple users to use the database concurrently? Thanks.
VIP
Windows 10 Access 2010 32bit
short answer no.
each user will end up having their own copy and only the last one to save will have their records saved.
MS MVP - Access Expert
Windows 8 Access 2013
Access can;t be used by multipel users at teh same time with any file sharing/syncing services (google, drop, dropbox, surgarsync, etc.).Originally Posted by Bazsl
Sharing an Access databes only work reliable on LAN.
Yo could use a remote SQL server and link to the tables.
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Posting Permissions
Reply With Quote