http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 12:18:20 +0000 Sun, 14 Jan 2007 14:36:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=6053 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=6053&PID=19314&title=strategy-to-keep-all-tables-synched#19314 Author: sserge
Subject: 6053
Posted: 14 January 2007 at 2:36pm

When you want to simply keep databases synchronized, catch "after-update" events, such as: EventAdded, EventChanged, EventDeleted. In those handlers add a code which would update the data in your custom tables.

You can access the DB file from another sources using any other methods. However, please remember that if you update DB file externally, you it will not be reflected on the Calendar UI until you reload all events...

--
WBR,
Serge
]]> Sun, 14 Jan 2007 14:36:51 +0000 http://forum.codejock.com/forum_posts.asp?TID=6053&PID=19314&title=strategy-to-keep-all-tables-synched#19314 http://forum.codejock.com/forum_posts.asp?TID=6053&PID=19077&title=strategy-to-keep-all-tables-synched#19077 Author: mpspark
Subject: 6053
Posted: 09 January 2007 at 2:08pm

Hello,

I am trying to build a scheduler whose data comes from multiple access tables such as rooms, classes, appointment tables, etc, but am thinking about just using the built in jet data provider. What will be the most efficient way to keep the scheduler db and all other legacy db tables synched? Changes made in my own tables should be reflected in the scheduler's db and vice versa.

Also, accessing the 'event.mdb' directly from other forms using DAO, either to create new, update, delete schedule events? Rest of the application is using DAO to handle the access db.

Thanks
]]> Tue, 09 Jan 2007 14:08:03 +0000 http://forum.codejock.com/forum_posts.asp?TID=6053&PID=19077&title=strategy-to-keep-all-tables-synched#19077