database update problems

Results 1 to 2 of 2

Thread: database update problems

  1. #1
    Join Date
    Dec 1969

    Default database update problems

    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>

  2. #2
    Join Date
    Dec 1969

    Default RE: database update problems

    did you check the properties, and security on this database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts