Re: What's the best way to open a recordset for insert only?



Do you mean:

rs.Open "SELECT * FROM +m_rsname+" WHERE 0=1", m_conn, adOpenStatic,
adLockBatchOptimistic, adCmdText

will let me call rs.AddNew ?

Yes. You should be able to call AddNew if lock type is not ReadOnly.

Stephen Howe


.