Table read before inserting a record using Recordset update

Hi,

Trying to insert a record using the records section option
(rs.addNew()). I think it reads the whole table. I'm using the query
"select * from table where primary key = 1" for opening the record
set. My DBA is reporting that she is seeing "select * from table"
query is issued very frequently (where as we never issue this query
from any where else).

I'm suspecting that addNew() function reads the whole table before
inserting the record, but not sure. Any ideas or suggestions?

Thanks !

Regards,
Baskar