Update table field with linked table field

[Zdz16]

Hi Expert;



I wanted to update one field of a table (i.e. DataTab) from a linked table (i.e. LnkTab) by using an update query. To do this in a select query, I did a join between DataTab and LnkTab. The results of the selection are OK. I switched the select query into update query.
I assigned the fields of the lnkTab table to the field of DataTab. During execution, after the warning message the following message displayed:

This ISAM driver does not support the update of data in a table attached

It is quite clear, but the concern is that this isn't the linked table is updated; here is the SQL statement of the query.

 
UPDATE DataTab INNER JOIN LnkTab ON  (DataTab.Row1 = LnkTab.Row1) AND 
                                     (DataTab.Row2 = LnkTab.Row2) AND 
                                     (DataTab.Row3 = LnkTab.Row3) AND 
                                     (DataTab.Row4 = LnkTab.Row4) 
 SET DataTab.Row5 = [LnkTab]![Row5];

I do not understand where I made the mistake. Your help and your comments and advice are welcome for a beginner.

Best regard

[orange]

What do row1, row2... represent?
Can you show us your table design?

[June7]

You have fields named Row1, Row2, Row3, Row4, Row5?

Bing: This ISAM driver does not support the update of data in a table attached

One possible cause/solution: http://support.microsoft.com/kb/824159

[Zdz16]

Thanks for your replies

It seems that the problem is known by Microsoft. He advises to import the linked table in the DB to perform the update.
Thats what I did. And this has solved the problem.