Cloud sync

Client is looking for some type of cloud sync...
1. He wants to keep data on PC1...
2. Sync that data to some cloud...
3. Be able modify data on the pc and auto sync to the cloud...
4. Occasionally use PC2...and able to access the data on the cloud...
5. Modify that data and add new documents...
6. Have that cloud data sync to PC1...

So...he wants all his data permanently on PC1...
Then auto sync that data to the cloud...
And on PC2 be able to access the cloud data...add new or modify...
And have that new data auto sync to PC1...

I was thinking about Msoft One Drive...but I'm not sure this will do
what the client is looking for...

Client is running Win 10 pro...

Are there any good options to be able to do this...???

Thanks in advance...
LVL 2
Steve MutchlerIT TechAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
It will. Under one important condition - that the two users never use it at the same time.
0
 
PatHartmanCommented:
Let me emphasize the NEVER part of Gus' advice.  If person 1 does not save the database prior to person 2 downloading it.  whoever saves last will overlay the other persons updates.  This is dangerous unless there is some way to know that another person has the app open and I don't know that there is.  So carelessness will be punished.  You should probably add code that closes the database if the app is inactive for 10 minutes.  This is not certain to save your bacon but it will help if you have users who are prone to opening the app and then walking away.
0
 
Gustav BrockCIOCommented:
You wouldn't download the database. You would sync the file on OneDrive with the OneDrive client to a local folder - at each machine - then open it from that local folder.
Whenever a change is made, it will automatically be synched within minutes to OneDrive in the cloud and then on the remote folder. It is completely transparent for the user.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
PatHartmanConnect With a Mentor Commented:
I know that Word and Excel are fine but are you sure that Access works this way?  Access opens the database in memory on the local PC.  It generally saves updated data back to the physical file frequently but if you are modifying objects, they must explicitly be saved and I'm not sure if that forces the physical file to be updated immediately.  I'm pretty sure that if two people have the app open, they will clobber each other.
0
 
Steve MutchlerIT TechAuthor Commented:
Oh boy...really quick responses...Thanks guys...
I guess I didn't make it clear...there is only ONE user....he has 2 laptops...he uses one laptop in the office
and the other laptop at home....so two users at the same time is NOT an issue...

Not using Access or any database at all...

This will be Work, Excel and maybe a Power point and probably Project files...

He uses Quickbooks but that will be ONLY on one laptop...

So...everyone agrees then that One Drive will do what the client needs...
0
 
PatHartmanCommented:
The topic list includes Access rather than office and so that explains our confusion.  Yes, One drive will work fine for what he wants to do.  I think you still may have to worry about leaving files open although if he is using the cloud versions of Word and Excel, there shouldn't be a problem.
0
 
Steve MutchlerIT TechAuthor Commented:
I see the confustion.
"And on PC2 be able to access the cloud data...add new or modify...
And have that new data auto sync to PC1..."

Access was used to mean...get into the cloud data...not the database program...

I gotta test this out yet...but I think it will work find...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.