In Query Design, No queries in add new table/query dialog box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike_mike - 16 May 2005 03:12 GMT

Hi
I have queries in my database. When i go into query design , +add table, no
queries are in the queries tab of the show table dialog box. Has anyone seen
this?

If i create a simple query eg. 'select * from table' it does appear? but all
my other query no longer show up.
I have compacted and repared the database and tried import everything into a
new database. Even pasting the SQL into a new query, dosen't work.i can't use
this new query in another queries design. This is a major bug!

help
mike!

Reply to this Message

John Vinson - 16 May 2005 03:24 GMT

>Hi
>I have queries in my database. When i go into query design , +add table, no
[quoted text clipped - 3 lines]
>If i create a simple query eg. 'select * from table' it does appear? but all
>my other query no longer show up.

Action queries - MakeTable, Append, Update, Delete queries - don't
return any records and therefore cannot be used from this box. Are the
queries you're missing perhaps in this category?

John W. Vinson[MVP]

Reply to this Message

mike_mike - 16 May 2005 04:49 GMT

Hi thanks!

just shoot me! must have left my brian at home!

thanks!
mike

> >Hi
> >I have queries in my database. When i go into query design , +add table, no
[quoted text clipped - 9 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 16 May 2005 05:55 GMT

>Hi thanks!
>
>just shoot me! must have left my brian at home!

<g> Well, I hope Brian was taking it easy and having a good time! Glad
to find a simple solution.

John W. Vinson[MVP]

Reply to this Message