Trigger Event

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Hey guys

Is there anyway from over a network that an excel file or
database can somehow send a communication or some sort of
response to force another Excel file to perform a query or
some kind of update?

What I am trying to do is when a change is made to an
Excel or database file, I want it to somehow trigger ane
vent that will force a remote excel file to perform an
action. I dont want the remote file to perform an action
if no change has been made to the database.


Will SQL, ADO, or some other method do what I need?
Any help or suggestions are greatly appreciated.
 
...
Is there anyway from over a network that an excel file or
database can somehow send a communication or some sort of
response to force another Excel file to perform a query or
some kind of update?
Click to expand...

How about getting the other Excel workbook to poll the database i.e.
query at regular intervals, looking for a change?

Jamie.

--
 
Wont that cause the Excel (Client file) to constantly be
busy checking for changes?
 
...
Wont that cause the Excel (Client file) to constantly be
busy checking for changes?
Click to expand...

Yeah, but how long does it take to test an internally held value
against a value in a database on the network? One second? And how
often would you need to poll the database? Every minute?

Jamie.

--
 
...
...


Yeah, but how long does it take to test an internally held value
against a value in a database on the network? One second? And how
often would you need to poll the database? Every minute?
Click to expand...

That wasn't meant to sound aggressive <g>. What I mean is, only you
can decide what is acceptable based on tests in your environment.

Jamie.

--
 
So there is a command called "On Change" that will notice
when the database has changed and then perform the query?

I assume this means that the query which will run every 5
seconds or so will detect the change and then perform the
query. Is this correct?


Thanks
Todd
-----Original Message-----
What about on the On-Change event, go to the other
Click to expand...
spreadsheet and perform a command??
 
Thanks

-----Original Message-----
...


That wasn't meant to sound aggressive <g>. What I mean is, only you
can decide what is acceptable based on tests in your environment.

Jamie.
Click to expand...
 
Back
Top