Re: Other Users don't see table updates
- From: "david epsom dot com dot au" <david@epsomdotcomdotau>
- Date: Fri, 10 Mar 2006 11:05:33 +1100
Database systems are not real time network communication
services. Where people really want real-time network
communications, they frequently use UDP or TCP over IP.
Where a database is also required, and there are only a
small number of users, people sometimes kludge live
updates by polling the database.
You can speed up the database polling and reduce the
load on the system by using a semaphore table (so the
users poll the semaphore table instead of polling the
data tables).
To get any of this to work, you also need to make
sure that the clients write back to the server in a
timely fashion. This also slows the clients and loads
the server, but again, it is justified in some cases.
Theoretically, you could use SQL Server to send a
network message to other users, but I've never seen
it done that way - normally, if you are going to
write code to send network messages, you can put it on
the clients anyway.
Rarely, people used sql server to send mail messages -
- this was the source of the infamous SQL Server worm
that almost brought down the internet - but that wasn't
really intended for real-time display update either,
because mail messages typically go through a "store and
forward" mail server.
(david)
"rdemyan via AccessMonster.com" <u6836@uwe> wrote in message
news:5d04d2b1ef7c5@xxxxxx
How does one handle the situation where two different users are looking at
bound forms that display data from a table.
User #1 makes a change to the data, but User #2 is just perusing the data.
User#1 has his bound form updated, but User#2 does not.
In this case User #2 is not seeing the actual current state of the data,
unless he/she does something to cause the data to refresh.
How do developers handle this, if at all?
If it were SQL SERVER as a backend, could one use a trigger on the table
to
cause screens to refresh of all users currently viewing data from the
table
that was updated.
I haven't given this much thought before, but now I'm wondering how this
is
handled.
Thanks.
--
Message posted via http://www.accessmonster.com
.
- References:
- Other Users don't see table updates
- From: rdemyan via AccessMonster.com
- Other Users don't see table updates
- Prev by Date: Re: Other Users don't see table updates
- Next by Date: Re: Database Splitter
- Previous by thread: Re: Other Users don't see table updates
- Next by thread: Re: Other Users don't see table updates
- Index(es):
Relevant Pages
|
