View Link Entry
Something that's always confused me is the differences when opening recordsets with ASP. After doing some searching tonight I found this simple answer in this forum. Essentially when using Set rs = cn.Execute(sql) it opens a read only record set while when using rs.open(sql) it opens a recordset which could be read-only, write, etc. Supposedly the first version is more efficient if you're only reading through a table.
By: Neal Grosskopf