Re: Editing disabled by alternative to INNER JOIN

From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
Date: Mon, 6 Aug 2007 21:01:37 -0500

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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

.

Follow-Ups:
- Re: Editing disabled by alternative to INNER JOIN
  - From: David W. Fenton

References:
- Editing disabled by alternative to INNER JOIN
  - From: cjakeman
- Re: Editing disabled by alternative to INNER JOIN
  - From: '69 Camaro
- Re: Editing disabled by alternative to INNER JOIN
  - From: Arch
- Re: Editing disabled by alternative to INNER JOIN
  - From: lyle
- Re: Editing disabled by alternative to INNER JOIN
  - From: cjakeman
- Re: Editing disabled by alternative to INNER JOIN
  - From: Bob Quintal
- Re: Editing disabled by alternative to INNER JOIN
  - From: David W. Fenton
- Re: Editing disabled by alternative to INNER JOIN
  - From: Bob Quintal
- Re: Editing disabled by alternative to INNER JOIN
  - From: Wayne Gillespie
- Re: Editing disabled by alternative to INNER JOIN
  - From: Bob Quintal
- Re: Editing disabled by alternative to INNER JOIN
  - From: David W. Fenton
- Re: Editing disabled by alternative to INNER JOIN
  - From: Bob Quintal

Prev by Date: Re: Missing Records in Linked Table
Next by Date: Adding Images to Reports from File Paths
Previous by thread: Re: Editing disabled by alternative to INNER JOIN
Next by thread: Re: Editing disabled by alternative to INNER JOIN
Index(es):
- Date
- Thread

Relevant Pages

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: Editing disabled by alternative to INNER JOIN
... Clicking design mode, 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: 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)
Re: Summing the Record Count from Multiple Tables
... running it in SQL mode but after saving the query to the name qrySumNCT, ... Jet engine cannot find the input table or query 'Select ... SELECT lngzBatchHeaderID, COUNTAS tally ... This worked but after saving it as a query I am getting an error message ...
(microsoft.public.access.queries)