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

Jumat, 27 Januari 2012

RE: [MS_AccessPros] Why is query not updatable?

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