DAO Notification?
-
I have an .mdb file (MS Access) that each employee will be using to tell who is in or out of the office. The .mbd file will be located on one of our servers. A windows program currently polls at a certain interval to refresh the status. Is there some built-in way to have notifications sent from the DAO objects instead of polling? I was also considering writing a server app and have each users program register with the server and handle it that way. If there is a better way, please let me know.
-
I have an .mdb file (MS Access) that each employee will be using to tell who is in or out of the office. The .mbd file will be located on one of our servers. A windows program currently polls at a certain interval to refresh the status. Is there some built-in way to have notifications sent from the DAO objects instead of polling? I was also considering writing a server app and have each users program register with the server and handle it that way. If there is a better way, please let me know.
No. Access doesn't support triggers or notification. SQL Server 2000 and above does. SQL Server 2000 needs a Notification Services extension installed. Search MS's site. SQL 2005 comes with it standard. A workaround method would be to implement something like a service, or .NET Remoting singleton, that manages access to the database, updating required tables and whatnot, but also exposing events that the clients subscribe to. When one client requests a change to the database, it does so through this service or object, which then fires your Changed event so the other clients get notified. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome -- modified at 11:06 Friday 6th January, 2006