Hi,<BR>I have problem updating sql database fr<BR>linked table in access.<BR><BR>let name the table as TableA and TableB.<BR>I have created a View between them <BR>and inner join table b and table a by id.<BR><BR>If i open both table together on access,<BR>and update the field in table a.<BR>It will generate an error<BR>"ODBC update on a linked table failed"<BR><BR>However if the close table b and update<BR>field on table a.No problem occur.<BR><BR>Could anyone tell me what is the problem.<BR>Thanks in advance for your help.<BR><BR><BR><BR><BR>