Recommended Posts

Hi,

 

I want to use a database and use bt sync to back it up to an off site machine. 

 

As any changes made to the daily diary interact with many tables within the database, when would a sync happen?

 

Tom

Share this post


Link to post
Share on other sites

It very much depends on your OS, the type of database and how that's accessed by the application using it.

 

If the application accessing the database "locks" the database the entire time during use, then syncing would only occur once the file is closed/released by the application using it or the application itself is closed.

 

If, on the other hand, the application using the database doesn't lock the file the whole time it is in use, only locks it when actually writing immediately unlocking again afterwards, syncing should then occur a few seconds after this (depending upon your operating system)

Share this post


Link to post
Share on other sites

Ok, so changes to files on Windows should be detected by Sync in "real time" - the issue remains though as to whether your Access database is "locked" the entire time it's in use, or only locked when actual changes are made to it.

 

This factor will determine how frequently Sync can access the file and synchronize changes.

Share this post


Link to post
Share on other sites

I simply use the database, how would I find out when it locks during writing etc?

 

Well, the simplest way would be to add the folder containing the file to Sync, and see when it syncs!

 

If it syncs a few seconds after each update to the database, the file isn't being "locked". If it doesn't sync until after you actually close the database/application using the database, then the file is being "locked".

 

Your original question was "when will sync happen" - best thing to do would be to try it and see! :)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.