Take Your Search Game to the Next Level with Dropbox Dash 🚀✨ Curious how it works? Ask us here!
Forum Discussion
Solved
Check mod dates on Dropbox file
Hi
I dare say this has been asked before, I couldn't find a topic/thread.
I am using DB to store an Access Database. This could be accessed by 3 or 4 people remotely who I've shared it with. The data could well have changed. When the office staff come in the following day, I need my C# windows app to checked the Server.ModifiedDate of database on Dropbox against its counterpart held locally, if the Dropbox version is newer then copy the dropbox one to local. At the end of the session, then to copy the local version to dropbox.
Simples! Yes?
I realise there are other questions about preventing access when one persons is using the database etc etc. I just wanted to get past first base, so to speak.
Any pointers would be gratefully received.
Thanks
Tony
I am using DB to store an Access Database. This could be accessed by 3 or 4 people remotely who I've shared it with.
Keep in mind that using a database file stored in Dropbox and shared with multiple people is a very bad idea. Data loss can occur. I'm sure you understand, since you mentioned preventing access, that each person has their own local COPY of the file, and that if multiple people are editing their copy, the last one to save it will overwrite any changes made by the other people.
I need my C# windows app to checked the Server.ModifiedDate
You can find the information you need in the API documentation.
3 Replies
- Rich
Super User II
I am using DB to store an Access Database. This could be accessed by 3 or 4 people remotely who I've shared it with.
Keep in mind that using a database file stored in Dropbox and shared with multiple people is a very bad idea. Data loss can occur. I'm sure you understand, since you mentioned preventing access, that each person has their own local COPY of the file, and that if multiple people are editing their copy, the last one to save it will overwrite any changes made by the other people.
I need my C# windows app to checked the Server.ModifiedDate
You can find the information you need in the API documentation.
Rich,
I do agree. Access is really only a single user, local DB. I want to keep the latest copy on dropbox. If its' changed since the local copy has been updated then copy from dropbox and then start my application proper.
Alternatively can we check, programmatically, that synchronisation had completed.
Cheers
After days of reading the API documentation, I think the penny's finally dropped.
Cheers😃
About Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.
