#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Posts
    1
    Rep Power
    0

    Registration form error


    Hi.
    I created a very basic eshop based on ASP and i get the following error when i click on register
    Code:
    Microsoft JET Database Engine error '80004005'  Operation must use an updateable query.
    PHP Code:
    ' Add New User to Database
     sqlString = "INSERT INTO users ( " &_
      "user_username, " &_
      "user_password, " &_
      "user_email," &_
      "user_address, " &_
      "user_city," &_
      "user_postcode," &_
      "user_cardnumber, " &_
      "user_cardtype, " &_
      "user_cardexpiremonth," &_
      "user_cardexpireyear," &_
      "user_cardname," &_
      "user_HTML" &_
      ") VALUES ( " &_
      " '" & fixQuotes( newusername ) & "', " &_
      " '" & fixQuotes( newpassword ) & "', " &_
      " '" & fixQuotes( email ) & "', " &_
      " '" & fixQuotes( address ) & "', " &_
      " '" & fixQuotes( city ) & "', " &_
      " '" & fixQuotes( postcode ) & "', " &_
      " '" & fixQuotes( cardnumber ) & "', " &_
      " '" & cardtype & "', " &_
      " '" & cardexpiremonth & "', " &_
      " '" & cardexpireyear & "', " &_
      " '" & fixQuotes( cardname ) & "', " &_
      " '"  & html & "' " &_
      ")"

    Con.Execute sqlString 
    Line 206 is
    Con.Execute sqlString

    For visa number you can use
    Code:
    4111111111111111
    Any help would be greatly appreciated
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,453
    Rep Power
    4539
    That error means the web server user account does not have file permissions to write to the .mdb file.
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester

IMN logo majestic logo threadwatch logo seochat tools logo