I have been working on an ms access application for about 3 years, and all of a sudden, one of the first update statements that I created about 2 years ago just starting hanging, and I can't figure out why. Please see the query below:
UPDATE mjm_attend_pay_indiv AS z SET z.deposit_flg = -1
WHERE z.row_id in
MJM_SCHOOL AS S, MJM_CLASS AS C, MJM_STUDENT AS ST, MJM_ATTEND_PAY_INDIV AS API, qry_Deposit_Slip_Total_Num AS TN, qry_Deposit_Slip_Amount AS A
API.PAID_FLG=-1 And API.DEPOSIT_FLG=0
pulled apart the update statement. The subquery works properly and returns 35 rows, and if I take out the subquery and hardcode values the update works. It just doesn't work together. Why would that be? Why would something that hasn't been updated in years, just start hanging? It doesn't error, it doesn't do anything, it just hangs eternally. Is there anything else that I can do, or try. I tried changing around the query, but I have a feeling it is something else. In the past I had an issue, and it turned out to be a random module that was causing a problem. I delete all of modules, and that didn't help this time.
Any sugestions would be much appreciated.