Annoying Access 2003 Query bug. Fix available?

  • Thread starter Thread starter OceanView
  • Start date Start date
O

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top