Hi,
I'm hoping someone might be able to help point in the right direction. Our IT department applied a patch update to windows 2000 overnight, which has had an impact on the Append queries in my DB.
Basically I have a number of append queries that use lookup tables to append the appropriate data from the underlaying table to the required table. They all have a relationship of "only include rows where the join fields from both tables are equal".
These were all working fine yesterday, but this morning, even though there is data in the underlaying table that meets the criteria, not data is being identified.
Has anyone any idea, as our IT department don't know and are not prepared to undo the patch update.
Your assistance would be most appreciated.
John
I'm hoping someone might be able to help point in the right direction. Our IT department applied a patch update to windows 2000 overnight, which has had an impact on the Append queries in my DB.
Basically I have a number of append queries that use lookup tables to append the appropriate data from the underlaying table to the required table. They all have a relationship of "only include rows where the join fields from both tables are equal".
These were all working fine yesterday, but this morning, even though there is data in the underlaying table that meets the criteria, not data is being identified.
Has anyone any idea, as our IT department don't know and are not prepared to undo the patch update.
Your assistance would be most appreciated.
John
