strategy to keep all tables synched

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
mpspark Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 09 January 2007 Status: Offline Points: 6	Post Options Post Reply Quote mpspark Report Post Thanks(0) Quote Reply Topic: strategy to keep all tables synched 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

sserge Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 01 December 2004 Status: Offline Points: 1297	Post Options Post Reply Quote sserge Report Post Thanks(0) Quote Reply 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