strategy to keep all tables synched
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=6053
Printed Date: 22 November 2024 at 11:53pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: strategy to keep all tables synched
Posted By: mpspark
Subject: strategy to keep all tables synched
Date 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
|
Replies:
Posted By: sserge
Date 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
|
|