When trying to insert data into an Access DB (ASP/VBScript), I get this
message:

Error Type:
Microsoft JET Database Engine (0x80040E57)
The field is too small to accept the amount of data you attempted to
add. Try inserting or pasting less data.

I was trying to insert 8 characters into a text field that holds 20. I
suspect that the real problem has nothing to do with the field size,
but is actually that the data I'm trying to insert contains a forward
slash (/). The DB can clearly store that kind of character as text, but
the page is balking at inserting it. Does this sound likely?

How do I get around this problem?
Thanks for any ideas!

Can you post the code you are using?

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Neen" <jgeddes [at] rogers.com> wrote in message
news:1157937341.937481.286150 [at] d34g2000cwd.googlegroups.com.. .
> When trying to insert data into an Access DB (ASP/VBScript), I get this
> message:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E57)
> The field is too small to accept the amount of data you attempted to
> add. Try inserting or pasting less data.
>
> I was trying to insert 8 characters into a text field that holds 20. I
> suspect that the real problem has nothing to do with the field size,
> but is actually that the data I'm trying to insert contains a forward
> slash (/). The DB can clearly store that kind of character as text, but
> the page is balking at inserting it. Does this sound likely?
>
> How do I get around this problem?
> Thanks for any ideas!
>

Neen wrote on 10 Sep 2006 18:15:42 -0700:

> When trying to insert data into an Access DB (ASP/VBScript), I get this
> message:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E57)
> The field is too small to accept the amount of data you attempted to
> add. Try inserting or pasting less data.
>
> I was trying to insert 8 characters into a text field that holds 20. I
> suspect that the real problem has nothing to do with the field size,
> but is actually that the data I'm trying to insert contains a forward
> slash (/). The DB can clearly store that kind of character as text, but
> the page is balking at inserting it. Does this sound likely?

Very unlikely. I have had no problems in the past with putting / into text
fields in Access via ASP/ADO.

> How do I get around this problem?

A copy of your code would help to see where the problem might be.

Dan