I have an old access2000 application running on pc with windows xp, this application connects to an SQL db on windows server 2003.
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.
I'm desperate because this problem mix data of different documents
Please help me
I'm sorry SINNDHO, following your faq link, i try to be more clear.
The application creates shipping documents for textile goods.
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]));".
I repeat the apllication 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 thank you in advance for your attention at my problem