ODBC table join gives ERROR when Updating row

[markcm]

Hi,

I am getting an 1809 error when I attempt to update a row from a joined recordset.

I know that the table JOIN is the problem because if I remove the second table (tbl System Summary), the update works correctly. Is there any way to do an ODBC update on a joined recordset??? Thanks, Mark.

The select statement follows:

SELECT [tbl Answered Call Profile].* From [tbl Answered Call Profile], [tbl System Summary] WHERE ((([tbl System Summary].[Start Time])=[tbl Answered Call Profile].[Start Time]) AND (([tbl System Summary].[End Time])=[tbl Answered Call profile].[End Time]) AND (([tbl System Summary].[ACD Group])=[tbl Answered Call profile].[ACD Group]) AND (([tbl System Summary].[Total Received])>0) AND (([tbl Answered Call Profile].[Average Speed of Answer])<=0))

The ODBC open recordset statement follows:

Set m_rsAnsweredCallTable(0) = con_AnsweredCall(0).OpenRecordset(SelectStatement, dbOpenDynamic, 0, dbOptimistic)