By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,087 Members | 1,508 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,087 IT Pros & Developers. It's quick & easy.

Add tables and queries dialog does not show queries

P: n/a
ATS
Hi,

I, and some collegues of mine, are running into a weird problem with
Access 2003. If I want to define a new query (or want to add a table
or query to an existing query), Access shows a dialog with three tabs:
Tables, Queries and Both (the exact names may be off, I am using a
Dutch version of Access). From this dialog, you can select the tables
and queries to use in your new query. However, the problem is that
switching the tabs does not seem to have any effect: the list of
database objects just displays all the tables, but no queries.
This is very annoying, as I frequently build queries on existing
queries. The only way to add them to the visual query designer now is
to switch to SQL view, enter some SQL with the query name in it, and
then switch back to the visual designer.

I have tried to search for a solution online, but the problem is that
I can not think of a set of set of search terms that yield anything
usefull. The terms all seem to general to use here unfortunately.

Can anybody here point me in the right direction?

André
Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ATS wrote:
Hi,

I, and some collegues of mine, are running into a weird problem with
Access 2003. If I want to define a new query (or want to add a table
or query to an existing query), Access shows a dialog with three tabs:
Tables, Queries and Both (the exact names may be off, I am using a
Dutch version of Access). From this dialog, you can select the tables
and queries to use in your new query. However, the problem is that
switching the tabs does not seem to have any effect: the list of
database objects just displays all the tables, but no queries.
This is very annoying, as I frequently build queries on existing
queries. The only way to add them to the visual query designer now is
to switch to SQL view, enter some SQL with the query name in it, and
then switch back to the visual designer.

I have tried to search for a solution online, but the problem is that
I can not think of a set of set of search terms that yield anything
usefull. The terms all seem to general to use here unfortunately.

Can anybody here point me in the right direction?

André
Instead of a right direction I'll throw some mud and hope some sticks.
You have a strange problem. Maybe there's some corruption in the
MsysQueries system table.

Have you compacted the database? If so, does that change anything?

If you create a new database, create a table, create a query, does it
show both when creating a new query?

Perhaps create a new blank database and import all objects from your
current mdb (also select MoreOptions to get menus and imp/exp
specification files). Does that help?

Maybe in the desktop icon add a
/decompile
to the command line and when it opens compact/repair it.

A little dance
http://www.youtube.com/watch?v=0OxJUzzlvKE
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.