Unanswered: Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
That is taken from the MS access specifications in help.
Can somebody please explain exactly what that means. Would this be the cause of "Property Value Too Large" when I attempt to save rather large tables?
I have a table with 209 fields in it, many are 35 character text fields. In its home database, I can not open up the talbe in design view at all. I simply get the message "Porperty Value is Too Large" and I am booted back to the database window.
However, if I import ONLY that table into an empty database, I can open it in design view, but I still get the "Property Value is too Large" error if I try to add ANY new field and save the table.
Help on my problem would be appreciated, as would any explanation of the max number of characters in a record.