Placing database on cloud storage
I want to put my database in cloud storage so I can access it from different computers which are in different locations (Florida & Connecticut). Can you provide some detailed guidance on how to accomplish this?
I want to put my database in cloud storage so I can access it from different computers which are in different locations (Florida & Connecticut). Can you provide some detailed guidance on how to accomplish this?
View our range of other financial planning products powered by the Economic Security Computation Engine
Disclaimer: ESPlanner and all other products provided by Economic Security Planning, Inc. (referred to hereafter as "we" or "our") are educational calculators designed to give you some input in mapping out your financial future, but should not be acted upon as a complete financial plan. MaxiFi Planner and the creators of MaxiFi Planner and any derivative products are not certified, registered, authorized, or any other type of financial planners. ESPlanner and its derivative products are simply tools for helping you think through your economic futures. Any suggestions should be viewed as informative inputs into your own decision-making with respect to saving and the purchase of life insurance. ESPlanner and its derivative products provide neither economic, financial nor tax advice, which can only be delivered to you by authorized professionals. The Social Security benefit estimates produced by ESPlanner are just that -- estimates. Only the Social Security Administration can tell you precisely the benefits to which you will be eligible or are eligible and the amounts you will receive. The estimates provided here may differ from the correct amounts due to mistakes in our computer code of which we are unaware or because of legislated changes in Social Security provisions of which we are unaware or because of delays in our updating our computer code for changes in Social Security provisions. This material is not intended to provide legal, tax or investment advice, or to avoid penalties that may be imposed under U.S. Federal tax laws, nor is it intended as a complete discussion of the tax and legal issues surrounding retirement investing. You should contact your tax advisor to learn more about the rules that may affect individual situations.
Copyright © 2021, ESPlanner || Patent Number: US 6611807 B1
Design by Zymphonies
Comments
dan royer
Wed, 07/22/2015 - 17:54
Permalink
I'm not sure that this will
I'm not sure that this will work. Well, you can try it. You'll see that in Tools/Options you can indicate the location of the database. If the pathname was the same from the point of view of both computers, perhaps it would work?
But certainly you could put your database in the cloud, then download it to the local computer, double-click it to invoke ESPlanner--work away--then put it back in the cloud when you are done. Then, from the other location, download from the cloud--work away--put it back on the cloud when you are done.
When you install ESPlanner one of the last steps is a little check box that says you are OK with associating .mdb files with ESPlanner. What this means is that when you double-click on an .mdb file it will launch ESPlanner and open that file (just like clicking on a Word .docx file runs Word). So if you installed ESPlanner on both computers, you really wouldn't have to worry about the database location in Tools/Options. Instead, just launch it from the file on your desktop or wherever.
I hope that makes sense.
Dan
ChrisCowles
Thu, 07/23/2015 - 10:07
Permalink
I don't know how other cloud
I don't know how other cloud storage apps work but OneDrive creates a local folder into which you copy your folders and files. It then syncs the files and folder structure within the target folder to the cloud and. In turn, the client app on other computers inherit the same files and folder structure.
I just copied my ESP database to my OneDrive folder (in my case, SkyDrive, because it uses the original name), set that copy as default in Tools>Options and started ESP normally. It now uses the cloud version as my default database.
I assume OneDrive takes care of the rest, and by setting the default database to point to that folder on different computers, those computer would have access to the same file.
Consider changing your default report folder to the shared location, too. That way the pointers in the database work to open the most recent report. If you have ESP set up to not overwrite the previous report, consider the effect on your available cloud storage. Clean it out once in a while.
I only did the above as a test but do use essentially the same approach with my home server. I just revise the default database to the copy stored on my server. Whether I open it from the desktop in the study or from my laptop while watching TV, I get the same.
dan royer
Thu, 07/23/2015 - 10:25
Permalink
Excellent.
Excellent.
daiglel
Fri, 07/24/2015 - 14:09
Permalink
Chris & Dan - Thanks for your
Chris & Dan - Thanks for your help. I use Google Drive and it works the same as Chris described with SkyDrive. So I copied my database to Google Drive and I set that location as the default for the database and the reports on both of my PC's. Works like a charm from both of my PC's. Thanks again for your help!
ChrisCowles
Mon, 07/27/2015 - 10:06
Permalink
Remember to close the app
Remember to close the app completely when finished using it on one computer. I don't know how the cloud apps handle open files. They might not be able to update the content on the cloud until local file locks are released. That could result in the various copies being out of sync.
Also, I you're just starting up one of your computers after a long downtime, consider how long it takes for the cloud app to update local file copies. It might not be immediate.