O
ODR via AccessMonster.com
Hi,
I think i know the answer to this one before i post!! but here goes anyway.
A bit of background:
I work for a manufacturer where i am creating an application so that we can
monitor the satus of the production machines live. There are 2 versions of
these machines, one type stores current data in a text file, the other type
stores in an XML file. For the text file version i can link to a table, i
then use the DLOOKUP function on a form which i refresh on the event timer.
This enables me to view the information directly from the machine live.
The problem:
The second type of machine stores in an XML file. Access does not seem to
offer a function where i can link to this file as a table. I know you can
import, but i don't think this would be ideal trying to import a table every
couple of minutes or so (it is also quite slow, though importing in excel is
almost instantaneous)
Solution:
Help!! Is there some way i can veiw this information in the XML file on my
form and refresh it?
Thanks
Sean
I think i know the answer to this one before i post!! but here goes anyway.
A bit of background:
I work for a manufacturer where i am creating an application so that we can
monitor the satus of the production machines live. There are 2 versions of
these machines, one type stores current data in a text file, the other type
stores in an XML file. For the text file version i can link to a table, i
then use the DLOOKUP function on a form which i refresh on the event timer.
This enables me to view the information directly from the machine live.
The problem:
The second type of machine stores in an XML file. Access does not seem to
offer a function where i can link to this file as a table. I know you can
import, but i don't think this would be ideal trying to import a table every
couple of minutes or so (it is also quite slow, though importing in excel is
almost instantaneous)
Solution:
Help!! Is there some way i can veiw this information in the XML file on my
form and refresh it?
Thanks
Sean