I have an app that's been in operation for quite some time where the Backend DBs are maintained on a LAN NAS. One DB is the host for "Business" data while the second is for "Personal" data. The user can switch back and forth as desired by simply pressing function key 9 ("F9") on the keyboard. In doing so, the app simply re-links the app's tables to the alternate. So far so good. Now, I have a new user that wants to share DB's between a home desktop machine and a laptop where the DB's are on Google Drive. I'll do a bit more investigation to gather more information here, but for now all I know is that Access is issuing some sort of warning that the backend DB has become corrupted.
The question becomes "so do I need to do something special when DB's are stored on a cloud drive"?
A second question, somewhat unrelated, is there a way to force a constant drive letter to a Google Drive? As one might expect, Windows Explorer on one computer isn't going to know what another computer is assigning. Obviously, unless the user is charged with having to learn how to use the Link Mgr I need to solve this issue as well.
Your thoughts please.
Thanks,
Bill