By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,080 Members | 1,817 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,080 IT Pros & Developers. It's quick & easy.

Can you use Access as an I.M. client?

P: n/a
Well, I guess the real question would be, can you talk to another
Access user through Access?

Here's my problem: when I need to get everyone out of one of our
databases, I have a form that tells me who is currently in it. Rather
than calling these people or running to their desks (some are in
another state), can I just pop up a box on their screen and tell them
it's time to get out for a minute?

I seem to remember doing this at some point at another job, but I can't
remember exactly how. But as I recall, that database had an OnTimer
event that checked every 20 or so seconds to see if a new message for
the user existed, and it was a bit clunky.

Jan 2 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"ManningFan" <ma********@gmail.comwrote in message
news:11**********************@48g2000cwx.googlegro ups.com...
Well, I guess the real question would be, can you talk to another
Access user through Access?

Here's my problem: when I need to get everyone out of one of our
databases, I have a form that tells me who is currently in it. Rather
than calling these people or running to their desks (some are in
another state), can I just pop up a box on their screen and tell them
it's time to get out for a minute?

I seem to remember doing this at some point at another job, but I can't
remember exactly how. But as I recall, that database had an OnTimer
event that checked every 20 or so seconds to see if a new message for
the user existed, and it was a bit clunky.
The usual method is to have a hidden form that is always open. In its Timer
event you periodically check for the presence of an entry in a message table
that is newer than the last time you checked. When no new data is found you do
nothing. When data is found you display it.

I have never attempted to use this to set up two way "chatting", but it is a
good way to send administrator messages to all users currently in the app. A
variation of this idea is that certain messages can also trigger a countdown to
an automatic "kick out" of the application in case the user is not sitting at
their PC.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Jan 2 '07 #2

P: n/a
ManningFan wrote:
Well, I guess the real question would be, can you talk to another
Access user through Access?

Here's my problem: when I need to get everyone out of one of our
databases, I have a form that tells me who is currently in it. Rather
than calling these people or running to their desks (some are in
another state), can I just pop up a box on their screen and tell them
it's time to get out for a minute?

I seem to remember doing this at some point at another job, but I can't
remember exactly how. But as I recall, that database had an OnTimer
event that checked every 20 or so seconds to see if a new message for
the user existed, and it was a bit clunky.
The following was not written for Access but may allow what you are
seeking:

Messenger Activity API

http://msdn.microsoft.com/live/msnmessenger/

You may also want to consider writing your own TCP/IP messenger.

James A. Fortune
CD********@FortuneJames.com

Jan 2 '07 #3

P: n/a

Open up a command window and type in "Net Send /?" for help on the
Net Send command.

But you probably really want Arvin's Kick Em Off system:
http://www.datastrat.com/Download2.html


On 2 Jan 2007 06:07:32 -0800, "ManningFan" <ma********@gmail.com>
wrote:
>Well, I guess the real question would be, can you talk to another
Access user through Access?

Here's my problem: when I need to get everyone out of one of our
databases, I have a form that tells me who is currently in it. Rather
than calling these people or running to their desks (some are in
another state), can I just pop up a box on their screen and tell them
it's time to get out for a minute?

I seem to remember doing this at some point at another job, but I can't
remember exactly how. But as I recall, that database had an OnTimer
event that checked every 20 or so seconds to see if a new message for
the user existed, and it was a bit clunky.

--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing

Jan 2 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.