Save query hang

[graveyard]

hi ppl, i have been tearing my hair apart over an issue i have been trying to fix for the past 2hours

I have a database in whcih i changed the fieldname. subsequently i changed the field for all the queries but i ran into problem with one of the query that contains this fieldname.

suppose i changed the fieldname (X) to (Y)

the table now contains (Y) and also (X) as an invalid fieldname. I opened up the query, delete (X) and try to save. Everytime i save, the query crashed and stopped responding. i can't also run because (X) will be there and the query will not extract the data. Even as i copied all the fields except (X) and put it into a fresh query, it cannot be resolved as the new query will still hang. this perhaps suggest the issue is with the remainig fields but i did not have any problem running the queries with the same set of fields.

can anyone adv on how to overcome this? thanks

 

[RainLover]

Take a SQL copy of the query from your last backup before it went wrong.

Post it into word and do a search and relpace. Then copy the result into a clean/new query. There should be no reason why this won't work unless you have done something else.