I have an old access2000 application running on pc with windows xp, this application
connects to an SQL db on windows server 2003.
The application creates shipping documents for textile goods.
in the last months we heve noticed a really strange problem, happening not very often but
very serious:
from a form we select some data and we fill a temporary table, then we launch a report that
reads from the form some data and other data from a query on the temporary table.
Sometimes the query seems not working because the report printout has correct data read from
the form but the data from the query are those of the last preceding successful query.
Checking the temporary table the data are correct.
herewith enclosed find an example of report and form.
In the report you see red circled data read directly from the form are always correct. The
green circled data are obtained from the simple following query and sometimes give the
problem.
Query: "SELECT Bollatex.* FROM Bollatex INNER JOIN Pezza ON Bollatex.CODPEZ = Pezza.CODPEZ
WHERE (((Pezza.NUMBOL)=[forms]![BOLLA_S]![NUMBOL]) AND
((Year([Pezza].[DATBOL]))=[forms]![BOLLA_S]![YEARBOLL]));".
The application is runnig from 8 years, we noticed the problem last months, the
only change was the substitution ( end 2010) of the pc with a new model but same operating
system (XP) same access 2000 version with SP3.
I'm desperate because this problem mix data of different documents
Please help me