Querry doesnt run after renaming it.

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

I have a situation where I create a querry with a
name "temp", initially when I start. After I finish
working on it, changing the design and satisfied that it
runs to my satisfaction, I rename it. After I rename and
run it, it doesnt run. It says enter value of the
parameter temp.xyz. I am sure there is no reference to
the old query "temp" in the SQL code

Where as If I copy the SQL and paste it into a brand new
query and run it, it runs fine. Is there a work around
for this wiered behaviour.

Thanks
Mario
 
Open the query in design mode.
Right click in the upper pane
select properties.
You will probably find a refernce to the old name there.
 
Back
Top