nathanb
07-17-2007, 07:37 AM
This has been on my mind for my mind for a while now... I have the following Sub with a simple SQL statement:
Sub email_queue_delete(entryid)
strSql = "DELETE * FROM EMAILS_QUEUE WHERE entryid=" & entryid & ""
objRS2.Open strSql, objConn, 1, 3
End SubDo I still need to include objRS2.Close if I am just deleting a record? Using an MS Access DB if that makes a difference.
Sub email_queue_delete(entryid)
strSql = "DELETE * FROM EMAILS_QUEUE WHERE entryid=" & entryid & ""
objRS2.Open strSql, objConn, 1, 3
End SubDo I still need to include objRS2.Close if I am just deleting a record? Using an MS Access DB if that makes a difference.