tommyliedl Posted August 13, 2014 Report Share Posted August 13, 2014 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 Quote Link to comment Share on other sites More sharing options...
GreatMarko Posted August 13, 2014 Report Share Posted August 13, 2014 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) Quote Link to comment Share on other sites More sharing options...
tommyliedl Posted August 13, 2014 Author Report Share Posted August 13, 2014 It is an access database, not designed by me, that i use to co-ordinate resources. We are using Windows 7 os. Quote Link to comment Share on other sites More sharing options...
GreatMarko Posted August 13, 2014 Report Share Posted August 13, 2014 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. Quote Link to comment Share on other sites More sharing options...
tommyliedl Posted August 14, 2014 Author Report Share Posted August 14, 2014 I simply use the database, how would I find out when it locks during writing etc? Quote Link to comment Share on other sites More sharing options...
GreatMarko Posted August 14, 2014 Report Share Posted August 14, 2014 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! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.