Insert is binge called updateable nature?

  • Thread starter Thread starter andyalean
  • Start date Start date
A

andyalean

Guest
Hello I have a problem with an insert query being said to have update properties.I am using asp page to to insert the data.
I get this error
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/Assignment 1/verifyNewRegisterStudent.asp, line 191

My database table has an autonumber PK and one column with a default value.
I don`t know why an insert could not take place?
When I test the query in sql window of access I could actually insert a few records but not in testing from asp.Please view my sql of asp page.

sqlDsuAddStdMemb = "INSERT INTO dsu_Members (Campus_Code, Member_MemberCategory, Member_FirstName,"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " Member_LastName, DsuUnit_Code, Member_SessionID,"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " Member_Username, Member_Password)"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " VALUES ("&stdCampusCode&", '"&membCaty&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " '"&stdFirstName&"', '"&stdLastName&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " "&stdDsuUnitCode&",'"&sessionID&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " '"&stdDsuUserName&"', '"&stdDsuPass1&"')"

Thanks for your help
 

Users who are viewing this thread

Back
Top Bottom