So for context, I have a database backend that is stored in Google Drive and I have a frontend with an interface, forms, and reports. The current solution that we have is that all employees in the company have Google Drive for desktop and the source database in the front-end points to the back-end file (as the google drive for desktop app mounts a virtual drive on the computer so it behaves like a local file). The problem comes when we distribute the front-end file to a third party. I would like to be able to distribute the front-end file to a third-party and the linked table source is the back-end file in Google Drive.
I found an ODBC drive for Google Drive online (https://www.cdata.com/drivers/googledrive/odbc/) but this program is quite expensive.
Provide a link to the database and a method in the frontend to relink the backend database.
Then the user can: