ASP/Access error - Updateable query

Results 1 to 4 of 4

Thread: ASP/Access error - Updateable query

  1. #1
    droy Guest

    Default ASP/Access error - Updateable query

    I&#039m trying to do a simple INSERT into an Access database with the following code: INSERT INTO tblTest2 (RespondentID) SELECT tblTest1.RespondentID FROM tblTest1<BR><BR>I get the following error message: <BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query. <BR><BR>Not sure what this means. Any help would be appreciated. Thanks.

  2. #2 Guest

    Default Show us your code!

    Maybe the error is not caused by what you think it is. If you show some of your code we may have a chance to help.

  3. #3
    Join Date
    Dec 1969

    Default RE: ASP/Access error - Updateable query

    you may need a where clause, not sure but thought it may help

  4. #4
    droy Guest

    Default RE: Show us your code!

    Below is my code: This is just a test to get it to work before I start working on the production stuff. Any ideas would be appreciated. Thanks.<BR>------------------------------------<BR><BR>Dim objConn, mySQL<BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.ConnectionString="DSN=Christensen"<BR> <BR> objConn.Open<BR><BR> mySQL = "INSERT INTO tblTest2 (RespondentID) SELECT tblTest1.RespondentID FROM tblTest1"<BR><BR> response.write mySQL<BR><BR> objConn.Execute(mySQL)<BR>

Posting Permissions

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