Query keeps looking for Query1 field

C

Cathy

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,
 
A

Allen Browne

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

Also check that Name AutoCorrect is turned off.
 
D

Dorian

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".
 
C

Cathy

The autocorrect was the issue. Thank you!

Allen Browne said:
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

Reply to group, rather than allenbrowne at mvps dot org.




.
 

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

Top