Message to user when table is changed

[georgesOne]

Good evening,

is it possible to let pop up a message for all or some users (the db is used by 10 people at maximum) if a table has been changed?
Preferably the message should pop up even if the db is closed.
I have a backend db with the tables and the 10 users use local frontend.
Any idea?

georgesOne

 

[Dalain]

One way to do this is in your BE table create a field called RecChanged (Yes/No)

Then in your FE, have a form's timerval set to 5 sec (5000) then in to onTimer event do a Dlookup on the field. So eevery 5 sec the form will search for a True value. If found, then active the popup message.

This will not work if the DB is closed. But if you use a time stamp you can check for all changes after a specific date/time than have your popup display when you open your BE.

You could also have this form in another FE which is running all the time.

Dalain

 

[georgesOne]

Thanks Dalain,

will try if I can get through it.
I am pretty new though, and may come back with a few additional questions.

georgesOne