Multiple table updates with SQL and ADO

<i><b>Originally posted by : Mark (question@paratrooper.net)</b></i><br />Ok, trying to use ADO (addnew) to insert into 2 tables (joined). I've separated the data and called an rs.update after each table but I keep getting.<br /><br />Microsoft OLE DB Provider for SQL Server error '80004005' <br /><br />Cannot insert or update columns from multiple tables. <br /><br /><br />If anyone has info or a link to an online tutorial on inserting/updating multiple tables that are joined via ADO, please email me and let me know.

<i><b>Originally posted by : notimportant (jhunt@alagreen.com)</b></i><br /><br />Use a stored procedure for this. There are many examples on the net!<br /><br />------------<br />Mark at 4/12/2001 10:49:35 AM<br /><br />Ok, trying to use ADO (addnew) to insert into 2 tables (joined). I've separated the data and called an rs.update after each table but I keep getting.<br /><br />Microsoft OLE DB Provider for SQL Server error '80004005' <br /><br />Cannot insert or update columns from multiple tables. <br /><br /><br />If anyone has info or a link to an online tutorial on inserting/updating multiple tables that are joined via ADO, please email me and let me know.