Query slow after being renamed

  • Thread starter Thread starter jamjar
  • Start date Start date
J

jamjar

Hi
I'm running XP and Access 2003.
I have a query running off an ODBC table that comes back in about 30s
normally.
I'm trying to rename it (also tried copying, save as, import from a backup)
and run it with the new name. When I do so, it takes several minutes to run.
I have several queries like this, so when I do a complete refresh what takes
about 10 mins with the old query names runs for hours.
Any suggestions why this is happening?

James
 
hi,
I'm trying to rename it (also tried copying, save as, import from a backup)
and run it with the new name. When I do so, it takes several minutes to run.
I have several queries like this, so when I do a complete refresh what takes
about 10 mins with the old query names runs for hours.
Any suggestions why this is happening?
Click to expand...
I thing it is the Name AutoCorrect feature. Turn it off for your database.



mfG
--> stefan <--
 
Back
Top