Re: Problem updating query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Richard (Richard_at_discussions.microsoft.com)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 13:11:05 -0800

Thanks for your advice - which fixed the issue & with regard to the links. I
will have to think about changing them...

Best wishes

Richard

"John Vinson" wrote:

> On Fri, 31 Dec 2004 06:55:02 -0800, "Richard"
> <Richard@discussions.microsoft.com> wrote:
>
> >Hi,
> >
> >I have a problem updating a query that calls fields from two tables - lined
> >on a common field. If I remove one of the tables, I can update the query.
> >
> >Could you please advise how I can change the SQL so that it allows me to
> >update the query. Here is the query in SQL view:
> >
> >SELECT [Transaction Log].[Property Address], [Transaction Log].[Transaction
> >Date], [Transaction Log].[Description of Transaction], [Transaction
> >Log].[Withdrwawal Amount], [Transaction Log].[Deposit Amount], [Transaction
> >Log].ID, [Transaction Log].[Vendor ID], [Transaction Log].[Contract ID],
> >[Transaction Log].[Capital Purchase], [Transaction Log].VAT,
> >Landlords.[Landlord Name]
> >FROM [Transaction Log] LEFT JOIN Landlords ON [Transaction Log].[Property
> >Address] = Landlords.[Property Address]
> >ORDER BY [Transaction Log].[Transaction Date];
>
> As Sylvain says, the Join is the likely source of the problem. This
> will be updateable only if there is a unique Index on the [Property
> Address] field.
>
> For what it's worth, I would be very dubious about using an address as
> a joining field! Unless you maintain strict (downright intrusive) data
> entry control, you'll risk missing links (312 W. Main St. is not a
> match to 312 W Main St. for example).
>
>
> John W. Vinson[MVP]
>

Relevant Pages

  • Re: RSA Challenges
    ... interrupt after Martha decides the ratty bias's log? ... willingness provides with regard to our advice after we sustain ...
    (sci.crypt)
  • Re: What happend to this group.
    ... Richard, have a close enthusiast. ... Jim accompany so shyly, ... hides with regard to the helicopter. ...
    (sci.crypt)
  • Re: The chart of comp.lang.c
    ... So howcome you have posted hundreds of messages ... advice - a destroyer rather than a builder. ... But by exaggerating and over-applying that ... Richard Heathfield ...
    (comp.lang.c)
  • Re: Firewire or USB 2: Which is faster?
    ... This is a forum for asking questions after all. ... could tear down the forum and just post a web site saying "Work it out ... >> Thanks everyone for the great advice and support, oh, except for Richard. ...
    (microsoft.public.windowsxp.general)
  • Re: Hydro or Wind Power
    ... but always had to work with their own money not be able to give ... >> advice? ... >> as a consultant I regard that saying as both malicious and libellous. ... Pat Gardiner ...
    (uk.business.agriculture)