Property value is too large.

[foru]

Hello fellow Access users...

I'm looking for a cause as to why this error is being thrown. I've designed a table based on a data file layout spec. There are 241 field (under the max 255), no indexes, and no expressions...

Why am I getting this error when I simply try to save a table with this design?

Here's the help that Access provides...
"This error can be caused by one of the following:

• The maximum number of columns allowed in a table or the maximum number of locks for a single file is exceeded.
• The indexed property of a field is changed from Yes (Duplicates OK) to Yes (No Duplicates) when duplicate data exists in the table.
• An expression is not specified in the Expression property of a calculated field.

If the maximum number of locks per file was exceeded, you can increase the number by editing a registry entry. However, this is not a recommended option.
If you use Registry Editor incorrectly, you could cause serious problems that require you to reinstall the operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
Make a backup of the registry. Find the MaxLocksPerFile registry value by using the Windows Registry Editor, and then increase the value. The MaxLocksPerFile value is saved as part of the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\ Access Connectivity Engine\Engines\ACE
If the Indexed property of a field and duplicate data is located in the table, reset the Indexed property to the previous setting, or remove duplicate records from the table."

[boblarson]

How do you have 241 fields in a table? WHY? What kind of data is this? Where's it coming from?

[foru]

it's a flat data file being sent from a vendor... each record has the potential (based on the data layout spec) to have 241 fields... this is test results and profile data.

[June7]

Can you provide the spec? I can test building the table in 2010 and see if the error reproduces.

You could try a link to the file if all you want to do is read the data.

[foru]

for more clarification...

the average field length is probably 5-7 characters

[boblarson]

Well, with 241 fields, you still can run into a paging issue where there is more data than can fit in a single page (I can't remember what the size is but something is telling me 4Kb). And that has to include system information. So, you may have a record which pushes things over the edge, so-to-speak.

[foru]

bob, thanks... there's not even any data in the table yet... does that same reasoning hold true???

[foru]

converting it from the pdf to a format that i can put out to you guys without the sensitive data

[foru]

here's the spec for the data file

[boblarson]

It might be the number of fields marked as required, possibly.