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
|
|||
|
|||
'Property value is too large' error message
Hello,
I have a large table that no longer allows any edits of any kind on it without giving the error message: 'Property value is too large'. I have looked this up and it occurs apparently when one has 'exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file.' (quote directly from Access Help). I have 203 fields in this table. We could of course divide this table into a couple of smaller tables, but we'd rather not at this point. I had put in Descriptions for every field in the table, and now, I am just trying to delete them in the interest of trying to recapture enough space to allow us to add a few fields, but Access is balking at everything, even deleting-- with the same error message. Access is just a front end data-entry application that gets sucked into a SAS program for statistical analysis, which is the major reason that we don't want to subdivide into multiple tables. Is there any way around this? Thanks. -- Pat Dools |
#2
|
|||
|
|||
'Property value is too large' error message
Compact the database & try again. If that doesn't work, create a new
datbase & try importing all the objects from the old one, into the new one. 203 fields is way too many for all but the rarest cases. Your table structure is probably not normalized. If you're not sure what that means, read-up on "database normalization", there are lots of article on the web. HTH, TC |
#3
|
|||
|
|||
'Property value is too large' error message
You can try to compact your database file. I assume you know what you are
doing with so many fields and SAS. -- Duane Hookom MS Access MVP "Pat Dools" wrote in message ... Hello, I have a large table that no longer allows any edits of any kind on it without giving the error message: 'Property value is too large'. I have looked this up and it occurs apparently when one has 'exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file.' (quote directly from Access Help). I have 203 fields in this table. We could of course divide this table into a couple of smaller tables, but we'd rather not at this point. I had put in Descriptions for every field in the table, and now, I am just trying to delete them in the interest of trying to recapture enough space to allow us to add a few fields, but Access is balking at everything, even deleting-- with the same error message. Access is just a front end data-entry application that gets sucked into a SAS program for statistical analysis, which is the major reason that we don't want to subdivide into multiple tables. Is there any way around this? Thanks. -- Pat Dools |
#4
|
|||
|
|||
'Property value is too large' error message
Sory, I overlooked the last bit re. why the table has so many fields.
TC |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What does error message "Property value is too large" refer to? | ardemiz | General Discussion | 1 | May 3rd, 2005 10:21 PM |
Property value is too large | Zuben | General Discussion | 3 | September 16th, 2004 10:24 AM |
How do I set up a large poster in Publisher? | War Eagle | Publisher | 1 | September 1st, 2004 10:50 PM |
Property sheet problem | Jim Orson | Using Forms | 4 | August 20th, 2004 04:13 PM |
Q2: KeepTogether property in Report Design View | Jeff Conrad | General Discussion | 3 | August 11th, 2004 07:35 AM |