send message to all users

[Guest]

I have a database on a network, if i want to make any changes all users
should close access.
Is it possible to send a message from access to all users that the should
close there access programm???

Harm Ozinga

 

[Wayne Morgan]

You may be able to. The only thing I can think of would be to follow the
links below to see who is logged into the database, then use Shell to do a
Net Send message to each of these computers. The Messenger Service (a
windows service) will need to be running to do this. You also have the
option of just sending the message to all computer in the domain instead.
Some of the newer Windows Service Packs disable the messenger service for
security reasons, so if you want to use it you'll need to set it to start
automatically.

http://www.mvps.org/access/general/gen0034.htm
http://www.mvps.org/access/api/api0062.htm

 

[Alex White MCDBA MCSE]

Only if you write it into the program,

or

use from the command prompt click on start/run type cmd click OK

type at the c:\>

net send * "There is a new version of our database, please close your
database"


works on NT/2000/2003 networks

 

[Guest]

thanks for your help.

 

[Douglas J Steele]

What I've done in the past is add a "Message" table to my database. I've put
a hook into every form (in the Activate event) that checks the Message table
to see whether there's anything there and displays a message to the user if
there is.

 

[Nikos Yannacopoulos]

Here's another idea... far-fetched? Maybe, but I'll throw it on the
table anyway.

Suppose you have a form (switchboard or other) that stays open at all
times; you can have a timer event on it to check the value of a field in
a single record table every two minutes (or whatever). If the value is
not zero, it opens a pop-up form which displays the appropriate message,
stored in another table with two fields, MsgID and MessageText, and
selected based on the value of the field in the former table; a couple
od lines of VBA code are enough to pick up the selected message and put
it in a label's caption (and possibly the form caption as well).
So, whenever you want to do it, all you have to do is change the value
of the field in the single record table.
Taking it a step further, you could also use the same method to kick
users out.

HTH,
Nikos

 

[Guest]

Douglas J Steele and Nikos Yannacopoulos,

Your ideas are realy brilliant!!!! I dit not think of such a solution,
Thank you, now I will work it out

gr Harm Ozinga (netherlands)