Workstation Messaging

I am currently working on a project for a hospital. Our current setup is 5 workstation and one server. Our server is using MS-SQL 7.0 while our front-end application is VB6. We want to implement a messaging system in which, for example workstation 1 can send a message to workstation 2 (a form will pop-up) notifying/dusplaying tge message.

Is there a way to do this in VB code ? Ur suggestions is highly approciated.
thanks.

there is a NetMessageBufferSend API that allows you to send messages between workstations.
You can also use the NET SEND command even from SQLserver via XP_CMDSHELL extended stored procedure