ACCESS FEED: Re: [MS_AccessPros] Why is query not updatable?

Jumat, 27 Januari 2012

Re: [MS_AccessPros] Why is query not updatable?

Ah, yes. I do see some duplicates so need to deal with those first. Will
come back if I still can't get it to work. Thanks!

James
www.james-mc.com
Words To Live By

On Fri, Jan 27, 2012 at 3:04 PM, John Viescas <john@viescas.com> wrote:

> **
>
>
> James-
>
> For the query to be updatable, the combination of Address, Zip, First
> Name, and
> Last Name must be the Primary Key or have a Unique index in one of the two
> tables.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Lahaina, HI)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of James
> McAlister
> Sent: Friday, January 27, 2012 10:50 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Why is query not updatable?
>
> I'm running this query, but see that it's not updatable. Is that because
> the FishingDistinct table is a linked Access table, or is there some other
> issue?
>
> SELECT Registrations.FishingFlag
> FROM FishingDistinct INNER JOIN Registrations ON (FishingDistinct.Address =
> Registrations.AddressFull8) AND (FishingDistinct.ZIP =
> Registrations.TEXT_RES_ZIP5) AND (FishingDistinct.FIRST_NAME =
> Registrations.TEXT_NAME_FIRST) AND (FishingDistinct.LAST_NAME =
> Registrations.TEXT_NAME_LAST)
> WHERE (((Registrations.FishingFlag) Is Null));
>
> Using Access 2010. Thanks!!
>
> James
> www.james-mc.com
> Words To Live By
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>