remote syncronization via dial up or ?

[ray436]

I realize I am likely opening a pandoras box but .......<br><br>Is it possible for me to set up a way our staff can dial in or go to our secure site an syncronize their replica of the database ?<br><br>right now we just ftp the database to our secure site, then periodically download the same when in the field. however this only allows updates to the field staff, not vice-versa.

 

[xtreme1]

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You might want to look into Carbon Copy 32, as it allows synchronization of files.&nbsp;&nbsp;I use it quite often, though it is usually a one way deal.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Once you commit the file transfer methods though, you could always write a query that compares the databases and concatates any new(unique) records from them both.&nbsp;&nbsp;This would form a new, and synchronized, database.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hope this was helpful, and good luck. <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>

 

[ray436]

thanks xtreme1, iwas thinking along those lines, however i think i may run into problems if some body compacts the db, i have had that cause a &quot; no common point to start from&quot; error in the past.<br><br>will keep trying diff queries.<br>