Be careful with automatic backup like to Google drive... If you get an infection it can affect your files and then they can be backed up automatically and hey presto, you've got infected files on your computer and infected files in your backup....
I create a folder on my PC ..
By way of example...
Call it "Nifty Transpose Tool" it contains the MS Access dB transpose tool, and all the saved backup versions created whist developing.
I create the same folder on Google drive.
From Google drive, I copy the files from the PC folder into the Google drive folder. Google drive has the facility to do this manually...
In this Google drive folder with the same name as the PC folder, I create a Google Doc with the same name as the folder but suffixed with Notes:-
Nifty Transpose Tool - Notes
I developed a python script and a Chrome extension which makes this an automatic document creation.
If anyone wants to try this out let me know and I will help you set it up.
I copy the link for both the notes and the actual drive folder into shortcuts to in the PC folder.
In the newly created Google Doc "Nifty Transpose Tool - Notes" the first thing I do is include the UNC of the folder where the associated files reside on my PC.
Once I've done some work on the latest version of the Microsoft Access database I am developing, I make a copy and rename it to the next version number for example:-
NiftyTransposeTool_2b.acmdb
I copy the UNC of the PC folder.
Then I click on the shortcut to open the Google drive folder, select upload file, add the UNC, choose the latest version of the mdb which is not being uploaded yet.
All done!!!
A single click on the shortcut in the PC folder will open the associated Google Doc "Nifty Transpose Tool - Notes" where I can moan about how shit MS Access is because it isn't working as I expect. Then a few hours later I can read those notes and laugh at myself because it was human error!
Now looking at this it sounds a bit long-winded but once it's set up, it's easy to do, also safe and foolproof!!!
I'll let you know when it's not foolproof!!!