• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Microsoft Access 2007. Delete selecting from multiple tables

why am I receiveng this error message when i try execute the query below even though I am able to switch to the dataView in access and see the records .
The tables exsists.


Delete x.*
from gimecontacts as X
inner join aa1123 as Y
On y.[email address] = x.email_address
WHERE y.[first name]  = x.first_name and y.[last name] = x.last_name and
 y.gime_id =x.primary_organization_id

ERROR MESSAGE : could not find specified tabe
0
wademi
Asked:
wademi
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I tried to emulated a similar query with the table alias's and the Join ... and I got a similar message.  Without the joins, no error message.

Not sure what's going on ...

mx
0
 
luconstaCommented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you change this to a Select, does it return the records you indicate?

You might try changing the Join type. In the query, right click on the line joining the two tables. Make sure you are returning the correct records, then try it again.

0
 
phhCommented:
Please try to add DISTINCTROW after DELETE, i.e:

Delete Distinctrow x.*
from gimecontacts as X
inner join aa1123 as Y
On y.[email address] = x.email_address
WHERE y.[first name]  = x.first_name and y.[last name] = x.last_name and
 y.gime_id =x.primary_organization_id
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yes, DISTINCTROW should work ... forgot about that ...

mx
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now