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

Disapearing tables in query design mode.

P: n/a
Opening one particular query in design mode shows a blank top half,
where the tables should reside. the bottom half is what I expect to
see with the field names over their table names over the sort and
criteria boxes, but the only way to add new fields or change
relationships is to edit from SQL view.

I've tried scrolling the window both left and right, up and down.
I've deleted the query, repaired and compacted then recreated the
query. After saving and closing, I repoened it to find the same
problem.

Any clues regarding the misbehaviour, I don't want to create a new
..mdb and copy everything, and discover the same issue. I will if I
must, but....

--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
In the top half right click and click "Add Table" to choose the tables
to add back in.
Not sure if that's what you're talking about.
FYI, I believe you can have only one table in the designer at a time
unless it is a SELECT query.

Nov 13 '05 #2

P: n/a
"Bob Quintal" <rq******@sPAmpatico.ca> schreef in bericht news:1114727322.7debc56ea65d6dbf74a8f853def3013d@t eranews...
Opening one particular query in design mode shows a blank top half,
where the tables should reside. the bottom half is what I expect to
see with the field names over their table names over the sort and
criteria boxes, but the only way to add new fields or change
relationships is to edit from SQL view.

I've tried scrolling the window both left and right, up and down.
I've deleted the query, repaired and compacted then recreated the
query. After saving and closing, I repoened it to find the same
problem.

Any clues regarding the misbehaviour, I don't want to create a new
.mdb and copy everything, and discover the same issue. I will if I
must, but....

--
Bob Quintal

PA is y I've altered my email address.


Hi Bob,
I think this will work for you:
-Copy the SQL of the query to the clipboard.
-Create a new query, go to SQL-view, paste the SQL
-Switch to design-view and voila your tables ...

--
Hope this helps
Arno R
Nov 13 '05 #3

P: n/a
Arno R said Hi Bob,
I think this will work for you:
-Copy the SQL of the query to the clipboard.
-Create a new query, go to SQL-view, paste the SQL
-Switch to design-view and voila your tables ...

It did, but after a while it suffers the same fate of invisible tables.
If I try to re-add them Access appends the "_1" suffix indicating it's
a duplicate copy. I added the other table as well, and when I deleted
one, both disapeared.

tools->database utilities-> repair didn't help.

I'm just worried about having to rebuild the entire mdb.

Q

Nov 13 '05 #4

P: n/a
> It did, but after a while it suffers the same fate of invisible tables.

What do you mean by 'after a while' ??
Query is as you designed again, but .... magically it's corrupt again ??
Please clarify.

There is always a possibility that 'weird things' happen with software ;-)

Arno R
Nov 13 '05 #5

P: n/a
"Arno R" <ar***********@tiscali.nl> wrote in
news:42*********************@dreader2.news.tiscali .nl:
It did, but after a while it suffers the same fate of
invisible tables.

What do you mean by 'after a while' ??
Query is as you designed again, but .... magically it's
corrupt again ?? Please clarify.

Exactly! after a while in this case is 2 hours.
There is always a possibility that 'weird things' happen with
software ;-)
I know, I've been programming for 35 years.
Arno R


--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.