Hi there, I am trying to create a form with an update field. When trying to update a picture of any size, 2kb - 50kb, I get the following error message.

Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/html/advertiser-premier-logo.asp, line 130

Line 130 reads.
127 Set MM_editCmd = Server.CreateObject("ADODB.Command"
128 MM_editCmd.ActiveConnection = MM_editConnection
129 MM_editCmd.CommandText = MM_editQuery
130 MM_editCmd.Execute
131 MM_editCmd.ActiveConnection.Close

The database that I am trying to update is in Access and the field is set at text.

Thanks.

Mally.

does this involved images (binary data) into Database?

try to set your field as OLE Object instead.

Thanks Micah, it worked perfectly.

Mally

Edited by - malhyp on 06 May 2006 09:53:33

Hi there, it worked just fine. If you try to update with out inserting an image, you get the following error... Is there something else that I have missed?

Response object error 'ASP 0101 : 80070057'
Unexpected error
/html/advertiser-premier-main.asp, line 0
The function returned |.

Thanks

Mally