Last post Jan 22, 2010 02:00 PM by Mikesdotnetting
Jan 22, 2010 01:41 AM|anil_khatri1305|LINK
I am using an access database to store my data. I have Add page which inserts data in the database. Also i have created an Edit page to read and then edit the data. In both these pages I am using FCKEditor. So I can take HTML values and insert in the database
for a field called Desciption. Now when I am inserting a data having a long value for the
Description field and then editing that data using the Edit page the Description field get locked and the update command doesn't work. This happens for a data having a long
Description value. I have used the datatype Memo for Description field.
Can anyone give me a solution for this problem....
Jan 22, 2010 03:10 AM|Mikesdotnetting|LINK
What do you mean by the field gets locked? Do you get an error message? If so, which one?
Jan 22, 2010 04:49 AM|anil_khatri1305|LINK
The error is "Could not save; Currently locked by another user"
Jan 22, 2010 02:00 PM|Mikesdotnetting|LINK
Probably permissions. Have you given the user account (ASPNET in XP, NETWORK SERVICE on Vista/Win Server 2003/2008) MODIFY permissions on the folder that the mdb file is in?