i have this problem too

rst.open "Select * from member where mem_ID=5",con,1,3

if rst.RecordCount<1 then

rst.AddNew

rst("Test")="A"

end if

rst("Test1")="B"

rst.update

rst.close

this example error on line "rst.update"

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[Microsoft][ODBC SQL Server Driver][SQL Server]The...