Hi,I have a strange query. I have a scheduled agent that has been running form past 7 years. It runs every 10 mins and fetches the data from an ACCESS table and dumps it into Lotus nOtes db. As soon as it deposits the data in Lotus notes it deletes the record from the MS-Access table. BUT From past 2 days it has been somehow retrieving OLD records nad putting them in Lotus notes db. I am really astonished as to how.
I am not using any cache also. This is happening only since past 3 days. What is the reason. Please help me. Also at a time there will be maximum 50 records only in the access table. I upgraded to 8.5 around 3 months back and didnt notice any such problem after the upgrade. Is there any way that I can flush this cache before fetching th enew record. My agent starts each day from 7:00 AM onwards.
My code is very simple
Set qry.Connection = con
Set result.Query = qry
stSelect= "SELECT * FROM TPDCustomerEmails_Out"
qry.SQL = stSelect
result.Execute
Do
result.NextRow
–
–
–