Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Calendar
  New Posts New Posts RSS Feed - strategy to keep all tables synched
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

strategy to keep all tables synched

 Post Reply Post Reply
Author
Message
mpspark View Drop Down
Newbie
Newbie


Joined: 09 January 2007
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote mpspark Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
sserge View Drop Down
Moderator Group
Moderator Group


Joined: 01 December 2004
Status: Offline
Points: 1297
Post Options Post Options   Thanks (0) Thanks(0)   Quote sserge Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.141 seconds.