J
John
Let's say I have a very simple table (Test) with a single
field (Col1) in it. I am trying to insert into it a value
from a text-box (txtBox) on a form (Test_Form). I have a
macro which activates the query that I wrote myself in SQL
View:
INSERT INTO Test
VALUES ([Forms]![Test_Form]![txtBox]);
Problem: If I enter up to 127 characters in the textbox
the Insert works fine. However 128 and more characters do
not get inserted and the whole database hangs completelly.
ANYTHING I try to do after that displays that message "
You can't carry out this action at the present time!", so
that I have to kill the database each time.
I tested it many times, the 128th character does it!
It's not the size limitation of the Col1 field in the
table because I tried declaring it as "Memo" datatype or
as "Text" with 255 size limit.
Please help me out!
field (Col1) in it. I am trying to insert into it a value
from a text-box (txtBox) on a form (Test_Form). I have a
macro which activates the query that I wrote myself in SQL
View:
INSERT INTO Test
VALUES ([Forms]![Test_Form]![txtBox]);
Problem: If I enter up to 127 characters in the textbox
the Insert works fine. However 128 and more characters do
not get inserted and the whole database hangs completelly.
ANYTHING I try to do after that displays that message "
You can't carry out this action at the present time!", so
that I have to kill the database each time.
I tested it many times, the 128th character does it!
It's not the size limitation of the Col1 field in the
table because I tried declaring it as "Memo" datatype or
as "Text" with 255 size limit.
Please help me out!