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: The suggestions and recommendations provided by Economic Security Planning, Inc.'s software tools and planning services do not constitute financial or investment advice. The creators of Economic Security Planning's software are not certified, registered, authorized, or any other form of financial planners. Economic Security Planning, Inc. is not an investment adviser registered with the U.S. Securities and Exchange Commission or any state securities agency, is not a registered broker-dealer and maintains no other regulatory credentials associated with the management of financial assets. Economic Security Planning, Inc. does not guarantee that the suggestions and recommendations derived from its software tools and planning services will necessarily achieve a secure economic plan. Like any software products, Economic Security Planning, Inc.'s software tools may have errors in its underlying code, and the assumptions about the future that it makes and that users input may prove false. In addition, output from the software tools and planning services may incorporate data obtained from third parties and such data (including any calculations that is based on such data) is provided on an “as is” basis. From time to time the output may contain errors that may be based upon, among other things, human data entry, aggregation and decompilation of data, processing of data through third party calculation engines and other processes that can give rise to errors. The company's financial plans and recommendations, including all of such plans and recommendations provided by its direct planning services, should be viewed as suggestive and informative educational inputs into your financial decision-making. None of our products or services recommend the purchase of specific financial products.
Copyright © 2023, 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.