Access 2007

[Arnold Siemsen]

I have recently switched from Access 2002 to 2007. I am now receiving an
error message: "Property Value is too large. Property Value cannot be larger
then 2K (error 3309) You are trying to set a property value of an object to
a size greater then the largest permissible size of 2K. Shorten the length
of the property value." I cannot find any help on error 3309. I do not know
which property value it is talking about. Please, I need help!

 

[Mark A. Sam]

Hello Arnold,

It would be helpful if you described what you are doing when the error comes
up, like opening a form, or running a query.

God Bless,

Mark A. Sam

 

[Arnold Siemsen]

It happens when I save a table that has manual entries. This has been
checked to be sure text, single, date, etc. are correct.
Arnold

 

[Mark A. Sam]

Without seeing the table I can't really help. I know that in the past when
I have had this type of issue, it was that the field size was suddenly too
small for the data. Maybe it is as simple as that or it could be Access
2007. There are definately issues for example, I was unable to apply
criteria in a query against a number field, for example Between 0 and
GetRadius(). Now I am crashing every time I open a table or query in design
view, so there may be some issue with tables in general.

Try this search in google, "Property Value is too large" access and you
will get some newsgroup threads on the error, but for earlier versions of
Access. Maybe you will find a solution.

God Bless,

Mark

 

[Arnold Siemsen]

I did the google routine several days ago. Help only for earlier versions.
I have 152 columns in the table and in earlier versions the limit (not
publicised anywhere) was 150. Thanks for trying to help.
Arnold

 

[Mark A. Sam]

Arnold,

A way to check if the column count is the problem would be to make a copy
and remove two columns from the copied table. If you dont get the error
that was it. I don't recall having a table with that many columns.

God Bless,

Mark