Annoying Access 2003 Query bug. Fix available?

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

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.
 

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

Similar Threads

Access 2000 Query very slow compared to SQL Query Analyzer 5
select query access 2000 0
Attendance Query 2
SQL Query Question (Access) 1
Access 2003 Query Bug? 3
Repost - Best way to get data from Access 2003 to Excel 2003 2
Attempting to create a function that i can use in a query. 1
Select query problems Access 2003 2

Top