sajid,j8�ëm²j(r‰

Hi All

I am developing a website using asp and access. I have some pages in which user can type very long text in a textarea and submit it. The long text is saved in a memo field. When text is small (e.g. 1000 characters), it is saved (as well modified) successfully. But when I try to submit very long data (e.g. 4000 characters), it generates following error:

[Microsoft][ODBC Microsoft Access Driver] Could not save; currently locked by user 'admin' on machine 'ABC'.

and the error number is 2147467259.

My code is

ProductID = request("Product ID")

Desc=request("Name")
ShortDesc=request("Short_Detail")
DetailDesc=request("DetailDescription")

mySQl= "select * from Product where idProduct='"&ProductID&"'"
call getfromdatabase(mySQL, rsModifyProduct ,"EditProduct")

rsModifyProduct("Description")=Desc
rsModifyProduct("Category")=Category
rsModifyProduct("ShortDetails")=ShortDesc
rsModifyProduct("DetailedDescription"=DetailDesc 'Memo Field

rsModifyProduct.update

*******************************
Database Manupulation Functions
*******************************

sub openDb()
if varType(connTemp)=0 or varType(connTemp)=1 then

' create the connection
set connTemp = server.createObject("adodb.connection")

connTemp.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Projects\MyProject\Database\MyProject.md b;"

end if
end sub

sub getFromDatabase(mySQL, rstemp, scriptName)

call openDb()

set rstemp = server.createObject("adodb.recordset")

rstemp.open mySQL,connTemp,3,2

end sub

sub updateDatabase(mySQL, rstemp, scriptName)

call openDb()

set rstemp=connTemp.execute(mySQL)

end sub

bob barrows

Sajid,
This post served no purpose:
1. You already had a thread going about this problem - starting a new thread
is merely an annoyance. It makes it very hard to carry on a conversation.
Don't bother to apologize: no apology is needed. I realize you are new to
this so you did not realize you were committing a breach of nettiquette.

2. You have added no additional information to help anyone solve the
problem- why would you expect someone to be able to help you just because
you posted the exact same problem again in the same newsgroup?

I will repeat that this is a problem involving asp and databases. There is a
newsgroup specifically devoted to such problems called
microsoft.public.inetserver.asp.db. That newsgroup gets a lot more traffic
than this one. If you want fresh eyes looking at your problem, I suggest you
post over there. But don't be surprised when people complain that they've
already seen your problem - I cross-posted my replies to your original
thread there. But it won't hurt if you go to that newsgroup, find the
original thread, and post a reply to it asking for somebody else to take a
look at the problem.

.....

I just reread the original thread, and realized I never made the suggestion
to upgrade your MDAC installation to the latest version. You can find MDAC
2.8 at http://www.microsoft.com/data

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"