Usually the link is lost, or a join no longer exists. I am surprised that
they are still functional. If a connection to a server is flakey, the query
may lose the link and it may later be established. If that is the case, you
need to fix it as soon as possible or you will eventually corrupt your
database.
When you close the query, does it prompt you to save it?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"Gina" <(E-Mail Removed)> wrote in message
news:9597B566-E10D-4982-9FC3-(E-Mail Removed)...
> What would cause the Tables to collapse in a query. Sometimes when I go
> into
> some of my queries the Tables are collapsed, they are still functional,
> but I
> have to extend them down each time.
>
> Not looking for extensive research, just any possibilities you might be
> aware of.
>
> --
> Gina