Edit data in datasheetview based on query with linked tables

[c_breemersch]

Hi,

I have a query with two tables (inner join).

When I create a datasheetview-form for this query, I can only update data of my main table.
When I want to change data of the many-table, I always get a write conflict:
"This record has been changed by another user since..."

(but no-one else is working in the database)

Is there a solution?
(Access 2003 + SQL 2005)

Regards,
Christophe

 

[dfenton]

Have you tried the Jet/ACE-specific DISTINCTROW predicate?