Error message: "record is too large"

C

Claude

I am receiving the message "record is too large" while entering data into my
form. Is there a "record" size limit? I know that the database has a size
limit, but does each individual record? I copy and pasted all data from one
(1) record into word to check the number of characters and had 3139
characters with no spaces. I can't find out anything in the help file online.
Thanks for the help!
 
V

Van T. Dinh

Yes. It used to be 2K but with UniCode introduced in A2000 (?), it may be
more (4K?).

Note that Memo Field value / OLE Field are not included in this 2K except
for 16 bytes (for pointer? to the Memo/OLE value) as Memo Field / OLE Field
values are stored separately from the Record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Fields Nested Too Deeply" Error in Simple Word Document 5
Copy previous record into form field 0
Improving Macro That Keeps First Letter 0
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
large dataset/import problems 5
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Error 3047 "Record is too large" --Please help! 6
A temp solution to "Record is too large" 2

Top