Re: Join deleted in Design view
From: Chris2 (rainofsteel.NOTVALID_at_GETRIDOF.luminousrain.com)
Date: 03/05/05
- Next message: Scott B: "Query needs tables switched"
- Previous message: Jason: "Re: calculate phonebills"
- In reply to: Ennex: "Join deleted in Design view"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 5 Mar 2005 09:28:38 -0800
"Ennex" <Ennex@discussions.microsoft.com> wrote in message
news:50F75117-821F-45B6-95E9-3B4150C3BA4D@microsoft.com...
>
> Hello Experts,
>
<snip>
> Can anyone see why Design view chokes on that join? And why does
that only
> happen after reopening the query with changes? Is there something
invalid
> about the join that is not caught in Relationships, and is not
caught when
> initially running the query, but is caught after making a change to
it?
Ennex,
MS Access' Query Design Grid just can't display all possible
configurations of the underlying SQL.
>
> If the join is valid, it's going to be hard to work on improvements
to this
> query if Design view is going to kill that join every time I make a
change to
> it.
I opened a new Query, switched to SQL view, saved the Query (it saved)
while still in SQL view, and then closed the Query while still in SQL
View. Now, if Access 2003 behaves like Access 2000 in this regard,
when selecting "Design View" to open the Query again, since it was
last closed in SQL View, it will open again in SQL View.
I was able to open and close it without problems, several times.
I then added columns to the SELECT clause, and that did not cause any
problems.
Essentially, as far as this particular Query goes, just operating in
SQL View from now on.
Sincerely,
Chris O.
- Next message: Scott B: "Query needs tables switched"
- Previous message: Jason: "Re: calculate phonebills"
- In reply to: Ennex: "Join deleted in Design view"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
