Network wide macro

[Mike]

I am trying to create a macro that will send a message to
all the people that currently have my database open to
tell them to close it. I can create the macro and it
will only show up on my computer. If this is not
possible please let me know. Any help would be greatly
appreciated. Thank you.

 

[Andre]

I am by no means a guru but I think this can probably be done. I don't think this is the best way but it will most likely work.
Create a table that tracks when a user is logged in and out. This table should also have a column that flags users, either "Message" or "No Message" . As administrator, you will have permission to set the colmn to "Message".

The actual application will then need to be set to:
-firstly periodically check this table for messages (timer control I guess)
-secondly to after executing some acction, to set that flag column for that user back to "No Message"

Your actual message will most likely have to be held as a CONST in the users application.

No guarentees but I think this could probably do the trick. It will require some VBA

Good Luck.

----- Mike wrote: -----

I am trying to create a macro that will send a message to
all the people that currently have my database open to
tell them to close it. I can create the macro and it
will only show up on my computer. If this is not
possible please let me know. Any help would be greatly
appreciated. Thank you.