Re: Editing disabled by alternative to INNER JOIN

"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in
news:_nQti.2449$ox5.1740@xxxxxxxxxxxxxxxxxxxx:

Bob Quintal wrote:
I use '97 at work, but have 2003 at home.
I did some comparison testing

In Access 2003. Saving from SQL view does cause the query to
cume up in SQL mode when selecting design mode with a closed
querydef. Clicking design mode, if the query is opened in view
mode, causes it to open in the builder, gives an error message
and then opens in SQL mode.

In Access '97, saving from SQL mode does not prevent the query
from opening in design mode. and after the message, opens in the
query builder, having deleted the join.

Service pack difference perhaps? I get the same behavior in 97
that you say you get in 2003.

As do I.

However, I *have* experienced what Bob describes, just not in the
test non-equi-join SQL that I've been using when posting in this
thread.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Editing disabled by alternative to INNER JOIN
    ... if the query is opened in view ... and then opens in SQL mode. ... saving from SQL mode does not prevent the query ...
    (comp.databases.ms-access)
  • Re: SQL Syntax Error
    ... Start/End ... in SQL mode as the code you gave me but will not work properly. ... get back into SQL mode I have to open the Query in Design view. ... search form without using one? ...
    (microsoft.public.access.queries)
  • Re: distinct key word
    ... In query design view, open the Properties box. ... I just wonder is it possible to create disctinct query in design mode ... that I do not need switch to SQL mode to modify my SQL statement? ...
    (microsoft.public.access.queries)
  • RE: Append/update Query with two sources
    ... Here's the SQL for what your trying to do. ... and then open a new query, switch to SQL mode, and paste it in, then switch ... This query uses the Zip from a table ...
    (microsoft.public.access.queries)
  • Re: HR Manpower Summary Report HELP!
    ... Now open the query 022806 Query in SQL mode and copy and paste the entire SQL ... (If there are subqueries, ... This is the name of the query that I am basing my report from. ...
    (microsoft.public.access.reports)