HELP with updateable query

J

Jacqueline

Using an Access 2000 mdb with linked SQL tables.

I am opening a report (based on a query)...after the
report closes I am running a simple macro to open an
update query to change the Yes/No field in a table.

I just finished doing the same thing with 2 other
reports...using the same tables...but with this one I am
getting this message after closing the report...

1. it says you are about to run an update query...BUT

2. then it says Operation needs to use an updateable
query...

I have reviewed both queries and reports and cannot find
any differences than the ones that work!!!
 
S

Steve Schapel

Jacqueline,

Can you post back please with the SQL view of the Update Query which is
showing this problem, and someone may be able to spot the cause.
 
J

Jacqueline

THANKS STEVE!
Here is the update query that I want to run after the
report closes...this is pretty much the same as the
select query that runs the report (minus the update to
YES part)
I have done exactly the same thing with another report
and it updates fine...I have no idea why this one doesn't
work!!

UPDATE (dbo_Users INNER JOIN dbo_Acknowledgement ON
dbo_Users.User_ID = dbo_Acknowledgement.User_ID) INNER
JOIN dbo_Additional ON dbo_Users.User_ID =
dbo_Additional.Personal_ID SET
dbo_Acknowledgement.Acceptance_Fee_FinanceReport = Yes
WHERE (((dbo_Acknowledgement.Acceptance_Fee_FinanceReport)
=No) AND ((dbo_Additional.Acceptance_Deposit)=Yes));
 
S

Steve Schapel

Jacqueline,

Your query is not updateable because it is based on 3 tables with a
many-to-one-to-many relationship. There is some good information in
Access Help regarding the conditions under which a query is updateable.
 
Top