Query keeps looking for Query1 field

Okay... so I have this bad habit of saving queries as Query1, Query2, etc if
I have not completed them and I get interrupted. It helps me get back to the
incomplete work faster/easier.

I have a DB that began as an Access 2007 DB (.accdb) and was converted down
to an Access 2003 DB (.mdb). Since then, these queries that began their life
as Query1, Query2... keep asking for fields from their old query name. I
have looked in the SQL, the Parameters, etc but can find no reference to the
old query name. One solution is to copy and paste the SQL into an empty
query and save it with the new name (again). What is causing this problem?
Where is this phantom Query1 information being stored? Is it because of the
backwards conversion?

Thank you,

Make sure there's nothing in the query's Filter or OrderBy properties.

Also check that Name AutoCorrect is turned off.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Cathy" wrote in message
...
Okay... so I have this bad habit of saving queries as Query1, Query2, etc
if
I have not completed them and I get interrupted. It helps me get back to
the
incomplete work faster/easier.

I have a DB that began as an Access 2007 DB (.accdb) and was converted
down
to an Access 2003 DB (.mdb). Since then, these queries that began their
life
as Query1, Query2... keep asking for fields from their old query name. I
have looked in the SQL, the Parameters, etc but can find no reference to
the
old query name. One solution is to copy and paste the SQL into an empty
query and save it with the new name (again). What is causing this
problem?
Where is this phantom Query1 information being stored? Is it because of
the
backwards conversion?

Thank you,

Whenever you delete an object in Access, it actually stays in the database
until you do a compact/repair.
You have provided your own solution. Recreate the queries in a fresh query,
delete the originals and then do compact/repair.
If this does not eliminate the problem, create a brand new empty dayabase
and import all your desired objects into it.
-- Dorian.
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Cathy" wrote:

Okay... so I have this bad habit of saving queries as Query1, Query2, etc if
I have not completed them and I get interrupted. It helps me get back to the
incomplete work faster/easier.

I have a DB that began as an Access 2007 DB (.accdb) and was converted down
to an Access 2003 DB (.mdb). Since then, these queries that began their life
as Query1, Query2... keep asking for fields from their old query name. I
have looked in the SQL, the Parameters, etc but can find no reference to the
old query name. One solution is to copy and paste the SQL into an empty
query and save it with the new name (again). What is causing this problem?
Where is this phantom Query1 information being stored? Is it because of the
backwards conversion?

Thank you,

The autocorrect was the issue. Thank you!

"Allen Browne" wrote:

Make sure there's nothing in the query's Filter or OrderBy properties.

Also check that Name AutoCorrect is turned off.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Cathy" wrote in message
...
Okay... so I have this bad habit of saving queries as Query1, Query2, etc
if
I have not completed them and I get interrupted. It helps me get back to
the
incomplete work faster/easier.

I have a DB that began as an Access 2007 DB (.accdb) and was converted
down
to an Access 2003 DB (.mdb). Since then, these queries that began their
life
as Query1, Query2... keep asking for fields from their old query name. I
have looked in the SQL, the Parameters, etc but can find no reference to
the
old query name. One solution is to copy and paste the SQL into an empty
query and save it with the new name (again). What is causing this
problem?
Where is this phantom Query1 information being stored? Is it because of
the
backwards conversion?

Thank you,

.