Showing updates on multiple workstations with ADP/SQL Server

[Steve Marshall]

Hello all. I have an application built as an Access 2002 ADP connected to
an SQL Server 2000 database. I have multiple users all accessing a screen
(i.e. form) of items requiring action. When one operator takes an item, the
record is updated to reflect that it has been "taken". However, this change
is NOT appearing on the screens on the other workstations, as it used to
before, when this was all implemented in Access 97 with an Access back-end.
This is causing major problems. Surely this is an obvious thing to need to
do? How is it achieved in the ADP/SQL Server environment? I have tried
setting the "Refresh Interval" down to 5 seconds in Access 2002's
Tools/Options/Advanced settings, but it doesn't seem to do the trick. There
MUST be a way to do this - can someone please enlighten me?

[Remove numeral from address if replying by e-mail]

 

[Vadim Rapp]

SM> Hello all. I have an application built as an
SM> Access 2002 ADP connected to an SQL Server 2000
SM> database. I have multiple users all accessing a
SM> screen (i.e. form) of items requiring action.
SM> When one operator takes an item, the record is
SM> updated to reflect that it has been "taken".
SM> However, this change is NOT appearing on the
SM> screens on the other workstations, as it used to
SM> before, when this was all implemented in Access 97
SM> with an Access back-end. This is causing major
SM> problems. Surely this is an obvious thing to need
SM> to do? How is it achieved in the ADP/SQL Server
SM> environment? I have tried setting the "Refresh
SM> Interval" down to 5 seconds in Access 2002's
SM> Tools/Options/Advanced settings, but it doesn't
SM> seem to do the trick. There MUST be a way to do
SM> this - can someone please enlighten me?


Access MDB is an application and database in one bottle, so it knows to poll
itself. With adp, the data is on another machine and under another application
(sql server). ADP by itself does not poll the server periodically, you have to
write the code to do it.

As for the Options/advanced, they pertain to Access as an application, not to a
specific project, so "refresh interval" is for MDB's only.

Vadim

 

[Chris]

Hi Steve,
See my earlier question in this group there have
been a few answers that may help you.

HTH
Regards
Chris