Hopefully some of you have already solved this. I have built a database for use on our LAN, with the back end residing on a shared network drive we purchased. At the end of the day, we put a backup copy of the back end onto our Google Drive account. Doing this allows our Office Manager/CFO to be able to pull information from home or while traveling. But she cannot see the current day until we run the backup at end of day.
I was wondering about just placing the backend out onto the Google Drive (our G drive on the network) so that ownership could get access of current data. But, at our location the internet connection is not always stable. We get our connection from a dish to dish setup that are about a mile apart (we are a rock quarry). We can't put ourselves into a situation where a outage would shut us down until the internet connection returned. Has anyone faced this, and what methods did you come up with to create a workaround? We create load tickets for outbound loads of rock and sometimes have 10 to 15 trucks lined up to cross the scales.
My very inexperienced thoughts were to store the ticket info locally and then update the cloud table when connection is restored, but we also store customer information and truck weights in the back end as well, and we would need to try to have a backup copy of that somewhere.
This may be out of reach with our technology......