Hi, need some help here.
In a multiuser environment, is there a way to broadcast some sort of a trigger to other users, whenever a user updates the database, so that all the other users' view of the database will automatically requery to get the latest data? If yes, how?

: Hi, need some help here.
: In a multiuser environment, is there a way to broadcast some sort of a trigger to other users, whenever a user updates the database, so that all the other users' view of the database will automatically requery to get the latest data? If yes, how?
:
:

One computer or multiple? Your own app or someone else's?

If it's on a single computer and it's your own app, you could send a custom message (BroadcastMessage) and intercept it using ordinary subclassing. I'm sure it's possible otherwise, but I don't know how...

: : Hi, need some help here.
: : In a multiuser environment, is there a way to broadcast some sort of a trigger to other users, whenever a user updates the database, so that all the other users' view of the database will automatically requery to get the latest data? If yes, how?
: :
: :
:
: One computer or multiple? Your own app or someone else's?
:
: If it's on a single computer and it's your own app, you could send a custom message (BroadcastMessage) and intercept it using ordinary subclassing. I'm sure it's possible otherwise, but I don't know how...
:

Multiple computer, multiple users. What I have is a datagrid that is bound to the database recordset. Multiple users will be viewing at this on their respective computers, and may be updating also. So what I want is that when 1 of the users add/modify/delete something in the database, all the other users' recordset views in their datagrid will automatically refresh, showing the newly updated data.

: Multiple computer, multiple users. What I have is a datagrid that is bound to the database recordset. Multiple users will be viewing at this on their respective computers, and may be updating also. So what I want is that when 1 of the users add/modify/delete something in the database, all the other users' recordset views in their datagrid will automatically refresh, showing the newly updated data.
:

You didn't say, but I'm guessing this is your own app or one you can modify. If you can determine how the computers are linked, you may still be able to do this fairly easily. For example, if it's a TCP/IP connection (pretty typical, I believe) and you can determine the IP addresses of the other computers, you can use winsock to send a message. Sending/recieving/acting on the message is simple; finding the addresses could be trickier unless they never change. This becomes even simpler if there's a central computer involved (so that two users don't manage to try to connect to a third system at the same time).