Property Value too Large

[raginggoat]

I have two fairly large tables that work just fine but I am trying to go inand remove the validation rules for all the fields with validation rules but I keep getting the "Property Value too Large" error when i try to save it after removing the validation rules.

 

[Kondwani]

you must make multiple tables and use the relationships to connect them. make use of foreign keys, etc.

Also the other option "the error message you get. click help at the bottom. it will explain about your "maxfilelock" <---something like this" what you have to do
is to change the maxlocks on you application registry.

go to start menu -> run ->type... "regedit" [ENTER]
find you maxfilelock and increase it. maybe you can search for a key and copy it.
i personally use the long way around it. foreign keys, etc.

maxfilelock, maxlock, maxprofilelock <---something like that...check your help on error

 

[raginggoat]

I'm not sure what i should change the registry value to. It is set at 251c hexadecimal and 9500 decimal.