Re: Multiuser application
I remember trying to do something simillar a while ago. I ended up opting for a timer method though.
I did find that there is an event in a dao data control called Data1_Reposition that, unless I am badly mistaken fires every time the data is changed. I still consider myself a novice using ado control though.
Hope this helps ya :)
Re: Multiuser application
How about, if you wrote an Active X program, which did all the DB handling for you? This progam could define the connection and recordset withevents. There is an event on recordset called recordchangecomplete and recordsetchangecomplete.
This program could then raise an event. If your program was to define (DIM) this program with events, then you would know that the recordset had changed.
I think for this to work, you would have to use DCOM (I don't know anything about DCOM - so this may be total rubbish), this way all programs would use the same active x program, so when the event fires, it will notify all client programs.
Hopefully this will be of some help, but if I'm way off, appologies.
Re: Multiuser application
If I were u then I would use a winsock control and on change I would send a mass message to all the users.
Re: Multiuser application
Thanks everyone for the quick replies.
For the type of application I'm working on, the best solutions seems to be the timer based system that I'm currently using.
However, you people gave me some insight on other possible solutions, so thank you.
Best regards,
Michael Nattfalk