i think the next error is because the database is open only readable. and i need some code that especified that table will be updateable.<BR><BR>the error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <BR><BR>file.asp, line 100 <BR>-----------------------------------------<BR><BR>the connect code:<BR>set conn= Server.CreateObject ("ADODB.Connection")<BR>conn.Open ("Driver={Microsoft Access Driver (*.mdb)};" &_<BR>"DBQ=db.mdb;" &_<BR>"DefaultDir=" & vPath & ";")<BR>---------------------------------<BR><BR>the error code:<BR>sqlstmt = "update table"<BR>sqlstmt = sqlstmt & " set cant=" & vcant<BR>sqlstmt = sqlstmt & " where prod=" & vprod & " and status=&#039c&#039"<BR>set rtemp=conn.Execute(sqlstmt)<BR>------------------------<BR><BR>if anyone know which and where the code goes, please response me.<BR>