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.
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
ERROR MESSAGE : could not find specified tabe