: : 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.