Hi.

My question is as follows.
I have an application which apx. 4 users will use. This app is connected to an MS-Access database.
For example, on the left side of the application, there is a treeview which contains a certain structure(retrieved from a table in the database). Each user is able to change this structure, i.e. add or remove nodes.
Now my little problem arrives. If one of the users adds(or removes) a node from the list, how do I notify the other users of the change?
Is there any event in the ADODB.Recordset object or the Connection object that fires when a change occures?

I've tried one solution, however I don't know wether it's the appropriate way of doing it.
I have table in the database called MainTbl, which contains only one record. This record has one field of Date type.
Every time a user changes the structure in the treeview list, the current time is written to the specified field.
In the application there is a timer control set to a specified interval which checks the MainTbl record, and compares it to a locally stored variable, which contains the time/date of the record the previous time the timer event occured.
If these dates/times doesn't match I update the treeview.

Hope someone could give me some information on this.

Regards,
Michael Nattfalk