If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007
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! |
#2
|
|||
|
|||
Access 2007
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" wrote in message ... 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! |
#3
|
|||
|
|||
Access 2007
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" wrote: 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" wrote in message ... 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! |
#4
|
|||
|
|||
Access 2007
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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
#5
|
|||
|
|||
Access 2007
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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
#6
|
|||
|
|||
Access 2007
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 "Arnold Siemsen" wrote in message ... 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" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|