ASP Forum
Microsoft JET Database Engine error '80040e21'
hiredp | Posted 10:53pm 29. December 2009 Server Time |

Microsoft JET Database Engine error '80040e21'

Could not update; currently locked

-----------------------
Any advice on these types of errors?

The page works most of the time... 9 out of 10

milchagros | Posted 8:06am 12. January 2010 Server Time |

I have the same error...
Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'id ='.

/admin/attach.asp, line 66



My code is:
<%
if not rs.eof then
  bg =  "#EBF5FC"
  while not rs.Eof

  

  if bg = "#ffffff" then bg= "#F1F1F1" else bg = "#ffffff"
  
  cmd3 = "SELECT * FROM peliculas WHERE id =  " & rs("pelicula")
set rs3 = CreateObject("ADODB.Recordset")
rs3.open cmd3, conn

cmd5 = "SELECT * FROM tipo where id =  " & rs("tipo")
set rs5 = CreateObject("ADODB.Recordset")
rs5.open cmd5, conn


%>


COULD SOMEBODY PLEASE GIVE ME A HAND WITH THIS?




Reply to Post Microsoft JET Database Engine error '80040e21'



Back to Forum Page