Need event suggestions

[ZRexRider]

Hi,

I am developing and MSAccess 2000 application (ADP) whose backend data
is SQL server. There is a server based (.NET service app) that runs on
a server who checks this SQL database periodically for new transactions
and when found places them in IBM Websphere MQ to be accepted by SAP.

One of the tasks I just received was to allow an operator of an Access
form to enter a document number that this .NET service will pass to SAP
via XML. SAP will return a complete record for this Document Number
and update the SQL database with data. There will be about a 5 to 10
second delay by the time the record is returned.

What I want to do is update the MSAccess form without having the
operator click a refresh button every couple of seconds. Is there a
way for an MS-Access form that is based on the results of a stored
procedure (using ADO) to be notified that the data has been updated?

Yes sounds kludgy but we don't have direct interactive access to SAP
and local standards require info requests to come in to SAP via XML.
SQL Server ends up being the "Intermediary". Basically Access puts a
request in the mailbox (SQL Server) and will get a response via the
same record being updated. I just want to automatically refresh the
MS-Access screen 10 seconds later when the data changes.

Anybody else ever have to do something like this?

Thanks

 

[Guest]

Quick and dirty: Just use a timer in VB to repaint the screen every ten
seconds.

Rob

 

[Dirk Goldgar]

Hi,

I am developing and MSAccess 2000 application (ADP) whose backend data
is SQL server. There is a server based (.NET service app) that runs
on a server who checks this SQL database periodically for new
transactions and when found places them in IBM Websphere MQ to be
accepted by SAP.

One of the tasks I just received was to allow an operator of an Access
form to enter a document number that this .NET service will pass to
SAP via XML. SAP will return a complete record for this Document
Number and update the SQL database with data. There will be about a
5 to 10 second delay by the time the record is returned.

What I want to do is update the MSAccess form without having the
operator click a refresh button every couple of seconds. Is there a
way for an MS-Access form that is based on the results of a stored
procedure (using ADO) to be notified that the data has been updated?

Yes sounds kludgy but we don't have direct interactive access to SAP
and local standards require info requests to come in to SAP via XML.
SQL Server ends up being the "Intermediary". Basically Access puts a
request in the mailbox (SQL Server) and will get a response via the
same record being updated. I just want to automatically refresh the
MS-Access screen 10 seconds later when the data changes.

Anybody else ever have to do something like this?

I haven't done anything like that, and I haven't worked with ADPs much
at all, but I'd guess you could use the Timer event of the form to do a
Refresh or Requery at some fixed TimerInterval. If you need to do this
only while specifically waiting for a response, you can set the form's
TimerInterval property to 0 while you're not waiting, and to a non-zero
value when you are waiting.

 

[ZRexRider]

That'll work - I hope! Thanks Dubya