On SQL Update: Microsoft JET Database Engine error '80040e0c' - Command text was not set for the command object
Posted on 2004-03-23
This is just annoying the heck out of me.
I have an asp page that is trying to update an access database. I can open the table ina recordset and update each record by looping through them, but when I call a SQL to do it I get:
Microsoft JET Database Engine error '80040e0c'
Command text was not set for the command object.
Since I know people will want to see source I broke it down to this, and it fails in a SQL update for me but works fine through the record set...
dim cnn: Set cnn = Server.CreateObject("ADODB.Connection")
dim strCnn: strCnn = "provider=Microsoft.Jet.OLEDB.4.0; data Source=\\psc_dev\PublicDatabase\complant\complant.mdb"
cnn.execute("UPDATE cmplnt SET NoDupeCheck=True WHERE RecId in (1,2,3,4)"
I have tried setting the connection mode to 3. I have tried adding exec before the update.. I am at a loss here....