Updatable Query

[cabobound]

I am writing a small webpage that needs a little data maint. The connection I have is the same I always use but now I am getting a "Operation must use an updateable query."

Set xConn = Server.CreateObject("ADODB.Connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("mcl.mdb")
xConn.Open DSNtemp

The sql does a simple update statement. Does anyone know why this would be happening?

K

 

[wvdba]

this is an access issue. security on the database must allow you to do an update. i have had this issue before. the ISP had to give me security permission to do an update to my database.