Take Your Search Game to the Next Level with Dropbox Dash 🚀✨ Curious how it works? Ask us here!
Forum Discussion
DVD1987
2 months agoNew member | Level 2
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
DVD1987 wrote:
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.
DVD1987 wrote:
I need my C# windows app to checked the Server.ModifiedDate
You can find the information you need in the API documentation.
3 Replies
Sort By
- Rich
Super User II
DVD1987 wrote:
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.
DVD1987 wrote:
I need my C# windows app to checked the Server.ModifiedDate
You can find the information you need in the API documentation.
- TonyC58Explorer | Level 3
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
- TonyC58Explorer | Level 3
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.6,000 PostsLatest Activity: 11 hours ago
If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.
For more info on available support options for your Dropbox plan, see this article.
If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!