Can't insert into database
I'm having trouble figuring out what is wrong with my query. I have the following code:
dim objConn, rsStudents, strSql
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Mode = adModeReadWrite
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\IMI\StudentData.mdb;"
strSql = "INSERT INTO Students (FirstName, LastName, SSN) VALUES ('" & fName & "','" & lName & "','" & ssn & "')"
However, when I try to view the ASP page, I get an "Operation must use an updateable query." error on the Execute line. What does this mean and what do I need to do to fix it?