I have set up an MS Access application to automatically compress and create a backup copy of its backend database the first time it is launched each day. It works great BUT the backup is saved on the same hard drive in the same office as the main database. If the hard disk crashes or the premises are damaged then we've lost everything. We have another office at the other end of town. Is there a way I can set it up so that it copies the backup to the server at the other office instead of the same computer? I imagine I need to set up a VPN somehow.
I am not even sure where to pose this question so I am open to suggestions.