Hi!
Of course, you can. However, you require to send a direct command to SQL Server and than refresh (or Resynch) records in the ADO recordset. Command like
"DELETE FROM MyTable WHERE PKIDFIELD=" + str(rs.Fields("PKIDFIELD").Value)
could be sent using command or connection objects Execute method.
HTH.
>Thanks for the reply Craig!
>
>Yeah, I knew I could make separate recordsets but I was hoping there was an easier way. I thought there was some way that you could say only update the one table and not the other when you do a delete.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.