Results 1 to 2 of 2

Thread: Updateable Query Error

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2000
    Posts
    80
    I've established an ADO connection to an Access DB on my local machine. When I try to pass an INSERT INTO statement to the connection.execute method, the browser pops up with an error that says "Must use an updatable query".

    This ASP code is in my global.asa file and I'm only trying to add 1 record. Any help on this would be greatly appreciated.


  2. #2

    Thread Starter
    Lively Member
    Join Date
    Jun 2000
    Posts
    80
    Thanks for the response. The Access DB was just for testing. It was gonna be scaled up to SQL Server. I gave up on the Access DB and just did it on SQL Server off of a DNS I created on my machine. It works now.

    The reason I have an INSERT statement in my global.asa file, is for the record that I create, I need to save the ID field value into a session variable.

Posting Permissions

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



Click Here to Expand Forum to Full Width