Error message: "record is too large"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Error 3047 "Record is too large" --Please help! 6
A temp solution to "Record is too large" 2
Record-Locking remains open after closing 0
large dataset/import problems 5
Add autonumber to a large table? 0
Linking Text File : Error : "Record Too Large" 1
What do I do when a message record is too large shows when adding. 2

Back
Top