Prev: vlookup in ms access
Next: Group By Desing View
From: Cathy on 28 Apr 2010 11:13
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,
From: Allen Browne on 28 Apr 2010 11:49
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" <Cathy(a)discussions.microsoft.com> wrote in message
news:F9C8F3F9-CBE0-4F5C-8F9D-0F2D3F9CA7AD(a)microsoft.com...
> 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,

From: Dorian on 28 Apr 2010 12:00
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,
From: Cathy on 28 Apr 2010 18:08
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" <Cathy(a)discussions.microsoft.com> wrote in message
> news:F9C8F3F9-CBE0-4F5C-8F9D-0F2D3F9CA7AD(a)microsoft.com...
> > 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,
>
> .
>
 | 
Pages: 1
Prev: vlookup in ms access
Next: Group By Desing View