Annoying Access 2003 Query bug. Fix available?

[OceanView]

I'm POSITIVE this is an access bug.

Example:
Query named Fred:

SELECT a1.caseNumber, a1.casetype, a1.appid, a1.parentappid, a1.country
, a2.countapp AS USChildCount
FROM Application AS a1 LEFT JOIN [select c2.casenumber,count(*) as
countapp from application c2
WHERE casetype in ('CON','DIV') group by ca.casenumber] AS a2 ON
a1.casenumber=a2.casenumber
Where a1.casetype='PRI';

Runs fine.

Rename the query Ethel using the database window. (When doing Save As,
this doesn't happen.)

When I run it, I get a parameter prompt "fred.casenumber:" But Fred no
longer exists ANYWHERE. Even if I remove casenumber the query, it stills
prompts for it. Doesn't matter what else I do. If I don't "save as" a
different name, this happens. It happens for some queries and not others
but I haven't found any reliable pattern.

Any clues?

 

[Jerry Whittle]

Open the database and go to Tools, Options, and General tab. Turn off Name
AutoCorrect. See if that helps. You may need to copy all the objects to a new
database file to completely clean things out.