If you want an Access-based solution: you could have a form that is
always open (perhaps the main menu form; perhaps a hidden form), and
that form would tick a timer, say once a minute. When the Timer event
occurs it inspects a table in the back-end database and if there is a
message there, it shows it in a Popup form (or a MsgBox).