Network wide macro

M

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

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