RE: rs.delete won't fly

[Ed Carp]

> The default locktype for a recordset is adLockReadonly, and as such you
> cannot modify the recordset's contents. See
> www.vbmysql.com/articles/cursorsandlocks.html
>
> You need rst.Open strSelect, conn, adOpenStatic, adLockOptimistic

Thanks, you beat me to it!  Having recently switched from DAO to ADO, I've
gotten caught by changes between DAO and ADO.  The solution is to specify
all of the parameters to the Open call :)

According to the ADO folks I've talked to, if you use adOpenStatic, you
won't se changes made by other people.  Maybe it doesn't matter.  I'd
suggest looking at the docs for Open, especially how ADO handles locking.