ACCESS FEED: RE: [MS_AccessPros] Failed update query

Senin, 29 April 2013

RE: [MS_AccessPros] Failed update query

Your query is not updateable since the join doesn't involve a primary key/foreign key relationship.

Can you create a UNIQUE index on ClubGmail.ClubName?

Duane Hookom MVP
MS Access

----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: robinski@mymail.net.au
> Date: Tue, 30 Apr 2013 13:49:54 +1000
> Subject: RE: [MS_AccessPros] Failed update query
>
> Thanks Duane,
>
> At 30/04/2013 12:41 PM, you wrote:
> >What are the primary and foreign keys?
>
> I have not used the term foreign key before.
>
> Primary key in ClubsEmail is 'ID"
>
> Primary key in tClubs is "ClubID"
>
> >If you change the query to a regular select query, can you update
> >the tClubs.Email column?
>
> No!
>
> Robin Chapple
>
>
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: robinski@mymail.net.au
> > > Date: Tue, 30 Apr 2013 10:08:35 +1000
> > > Subject: [MS_AccessPros] Failed update query
> > >
> > > I have an update query that does not execute.
> > >
> > > Just one field is to updated from another table. it does not give an
> > > error message and it foes not update!
> > >
> > > UPDATE ClubGmail LEFT JOIN tClubs ON ClubGmail.ClubName =
> > > tClubs.ClubName SET tClubs.Email = [ClubGmail]![email];
> > >
> > > What have I missed?
> > >
> > > Many thanks,
> > >
> > > Robin Chapple
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>