MsAccess2003/SQL Server : Query should be updateable

I have a problem with an Access Update-Query (made in the designer) for a SQL-server Table.
The Query consists out of the Table to be updated, and a joined "Select" subquery to provide the occurences to be updated.

I always get a "query should be updateable" error-message.

- SQL Server rights are OK, I can modify the table by hand (in MsAccess)
- Update Query without the "Select" query is OK
- Primary key-fields are available

I don't understand what's going on. I've been googling, found a huge volume of similar posts, some with workarounds eliminating the "Select" query. Unfortunatly I need the Select-query.

Why is the Select-query influencing the rights of the Update-query ? IMHO this shouldn't.
What can be done to solve this ?
I would like to understand the reason of this behaveour

Thanks

PS: The same happens in similar Query's upon other tables/subqueries

re: MsAccess2003/SQL Server : Query should be updateable

You haven't given us anything to work with. There are a few reasons why a query is non updateable. You have to at least give us the SQL code you're using.