Link to home
Start Free TrialLog in
Avatar of Steve Mutchler
Steve MutchlerFlag for United States of America

asked on

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...
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve Mutchler

ASKER

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...
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.
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...