HELP with updateable query

  • Thread starter Thread starter Jacqueline
  • Start date Start date
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!!!
 
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.
 
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));
 
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.
 
Back
Top