T
theoldschool
This is my first posting to this forum and I hope someone can help. I a
running the Homeseer program which logs (via a plug-in) temperatur
data to a MS Access file every 5 minutes e.g. table 1 holds say outsid
temperature, table 2 holds say living room temperature etc. A query i
then set up to collate all the table data into and this is the
accessed to produce a graph to display historical information. M
problem is that when the mdb file is small, all the data in the table
is transferred to the query but after a while, not all the data in th
tables appears in the query. For instance at 6pm my current mdb fil
has 2000 entries - if I check the tables the latest temperature record
are present and correct but if I check the query, the latest record i
around 4pm - i.e. 2 hours ago. For some reason not all of the data i
the tables is being picked up by the query and the situation gets wors
the larger the database gets - i.e. more & more of the later dat
doesn't get picked up.
Anybody any ideas??
running the Homeseer program which logs (via a plug-in) temperatur
data to a MS Access file every 5 minutes e.g. table 1 holds say outsid
temperature, table 2 holds say living room temperature etc. A query i
then set up to collate all the table data into and this is the
accessed to produce a graph to display historical information. M
problem is that when the mdb file is small, all the data in the table
is transferred to the query but after a while, not all the data in th
tables appears in the query. For instance at 6pm my current mdb fil
has 2000 entries - if I check the tables the latest temperature record
are present and correct but if I check the query, the latest record i
around 4pm - i.e. 2 hours ago. For some reason not all of the data i
the tables is being picked up by the query and the situation gets wors
the larger the database gets - i.e. more & more of the later dat
doesn't get picked up.
Anybody any ideas??