Click to See Complete Forum and Search --> : Can't update a record in access using asp


raj_2006
06-06-2008, 03:33 PM
Hi All,

I am trying to update a record using asp and access and getting a strange error.

I really don't know how this is happening.The error is:

Error Type:
Microsoft JET Database Engine (0x80040E21)
Could not save; currently locked by another user.
feature_admin.asp, line 213

in line 213 there is

<%rs_savefeature("cBody") = request.form("cBody") %>

In the access database the datatype of field cBody is memo.

Could you please suggest me what should I do now?

Thanks in advance for your co-operation.

Regards,
Raj

russell
06-08-2008, 12:59 PM
someone (you?) has the access database open. close it.

raj_2006
06-08-2008, 03:44 PM
Hi Russel,

The db is closed while doing the update.I think the problem is somewhere else....but unable to find it... :confused:

Raj