Access Query Problem

Results 1 to 3 of 3

Thread: Access Query Problem

  1. #1
    Join Date
    Dec 1969

    Default Access Query Problem

    I figured out how to connect to my database (I wrote the previous question). I&#039;m using:<BR><BR>conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("EmailProject.mdb")<BR><BR>However, now it rejects this SQL statement (while it does process some others with no problem). <BR><BR>The SQL is:<BR><BR>&#060;%<BR>SQL = "INSERT Into People (Email_1, Firstname, LastName, OriginalPM, WildcardPM, EastsidePM, SeattleWorks, SpecialEvents) VALUES ( &#039;ag&#039;, &#039;ag&#039;, &#039;ga&#039;, 1, 1, 0, 0, 0)"<BR><BR>SET rsUser=conn.execute(SQL)<BR>%&#062;<BR><BR>The Error Message:<BR><BR>Microsoft JET Database Engine error &#039;80004005&#039; <BR>Operation must use an updateable query. <BR>/UpdateEmail.asp, line 142 <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Query Problem

    the folder which contains the .mdb file needs write permissions. you have it set to read only<BR><BR>j

  3. #3
    Johnny Hughes Guest

    Default RE: Access Query Problem

    Look at this ASPFAQ...It has the most common causes:<BR><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