INSERT string into a Microsoft Access Database
Hello,
I am trying to insert values into a microsoft database, but I keep
getting the following error message: "Operation must use an updateable query" I do not know why I am getting this error.. can someone please help me?
Here is the code I have:
Dim objComm, conntemp
conntemp = "Provider=Microsoft.Jet.OLEDB.4.0;"&_
"Data Source=c:\inetpub\wwwroot\GCIESEquipment\Database\ mdns1.mdb;"&_
"Persist Security Info =False"
set objComm = Server.CreateObject("ADODB.Command")
objComm.ActiveConnection = conntemp
objComm.CommandText = "INSERT INTO defectiveEquipment(name, email, phone) VALUES " &_
"('" & name & "','" & email & "','" & phone &"');"
objComm.CommandType = &H0001
objComm.Execute
|