Could not update; currently locked.

[tarasios]

I am using ASP to insert data from a web page into an Access 2000 db. Am using Dreamweaver 2004 MX for the ASP pages. I occasionally get this error and don't know why. There is no locked file associated with it. It just stops and then I have to wait an eternity for it to "clear." Any ideas? Thanks.

Full error message:

Microsoft JET Database Engine error '80004005'

Could not update; currently locked.

...survey.asp, line 82

[Bhanu]

close rs and the db link to get rid of this problem.
Bhanu

[tarasios]

Thanks Bhanu. Closing the connection (conn) after the insert seems o have done the trick. :)

end of code:
rs3.Open sql3, conn3
conn3.close