Update Database question

Results 1 to 2 of 2

Thread: Update Database question

  1. #1
    Matt1999 Guest

    Default Update Database question

    I am trying to update an access database (Change a password).<BR>What am I doing wrong? It gives me an Error:<BR>-----------------------------------------------------------<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <BR>line 20 <BR>-----------------------------------------------------------<BR><BR>Code:<BR><BR> Set Cm = Server.CreateObject("ADODB.Command")<BR> Cm.ActiveConnection = "LoginDSN"<BR> Cm.CommandText = "UPDATE tUsers SET UserPassword=&#039 12345&#039" & _<BR> "WHERE UserName=&#039 1367A&#039"<BR> Cm.CommandType = 1<BR> Cm.Execute (This is Line 20)<BR>

  2. #2
    Matt1999 Guest

    Default RE: Update Database question

    Looks like my ODBC connection was set as READ ONLY! gezz!

Posting Permissions

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