Take Your Search Game to the Next Level with Dropbox Dash  🚀✨ Curious how it works? Ask us here! 

Forum Discussion

DVD1987's avatar
DVD1987
New member | Level 2
2 months ago
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

  • 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

  • Rich's avatar
    Rich
    Icon for Super User II rankSuper 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.

    • TonyC58's avatar
      TonyC58
      Explorer | 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

      • TonyC58's avatar
        TonyC58
        Explorer | Level 3

        After days of reading the API documentation, I think the penny's finally dropped.

        Cheers😃

About Dropbox API Support & Feedback

Node avatar for Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.6,000 PostsLatest Activity: 11 hours ago
382 Following

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!