Live Data in Access

[Nate]

I am having trouble getting live data in my Access Database. The data is
retrieved from Thompson One. In Excel, this is a simple formula such as
=ilx...As the market chages, the quote is updated in Excel. I would like to
have a text box in an Access form that is similar and updates as the market
changes (i.e. bid/ ask).

If this canno't be done in Access, is there a way to have a live link to an
Excel spreadsheet? As the data changes in Excel, the linked table in Access
changes as well. This has been a thorn in my side, any help would be greatly
appreciated.

 

[Pat Hartman]

You can do this in Access if you can find a web service to provide the data.
Look at the code behind the Excel sheet and see if you can copy it.

 

[Nate]

The service used is Thompson One, which uses ILX data. The code is password
protected, but is labeled as ilx.xla. Various ilx options also show up under
references in access (as .dll files). Do I need to write a module to
reference the .ilx options? If so, do you have any sort of examples, or
examples of referencing a web service?

Thanks in advance

 

[Pat Hartman]

We have exhausted my knowledge of this particular subject.