Query Error -

Results 1 to 2 of 2

Thread: Query Error -

  1. #1
    Join Date
    Dec 1969

    Default Query Error -

    Hi,<BR><BR>I get the following error when trying to insert or update a new record to my access database.<BR><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>My code for the Command is:<BR><BR>SET cmdInsertPhoto = Server.CreateObject("ADODB.Command")<BR>cmdInsertP hoto.ActiveConnection = MM_connUsers_STRING<BR>cmdInsertPhoto.CommandText = "INSERT INTO etc etc"<BR>cmdInsertPhoto.CommandType = 1<BR>cmdInsertPhoto.CommandTimeout = 0<BR>cmdInsertPhoto.Prepared = true<BR>cmdInsertPhoto.Execute<BR><BR>Has anybody had a similar problem?<BR><BR>Thanks in advance<BR><BR>James<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Query Error -

    I think the problem may be in your query. You should post the rest of that "Insert" statement.

Posting Permissions

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