By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,421 Members | 1,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,421 IT Pros & Developers. It's quick & easy.

Property value

P: 14
Hi all,

Quick question, I have a access db that have tons of tables some of which are linked. Recently there was some addition of fields in one of the linked table which subsequently needs to added to my tables. When I try to add the new field I get the following error "PROPERTY VALUE TOO LARGE" Can anyone assist.
Jun 12 '07 #1
Share this Question
Share on Google+
5 Replies

JConsulting
Expert 100+
P: 603
Hi all,

Quick question, I have a access db that have tons of tables some of which are linked. Recently there was some addition of fields in one of the linked table which subsequently needs to added to my tables. When I try to add the new field I get the following error "PROPERTY VALUE TOO LARGE" Can anyone assist.

some examples of data and data types would help.
Access can only store up to 16 numbers in a numeric field.
Jun 13 '07 #2

Expert 100+
P: 344
Hi all,

Quick question, I have a access db that have tons of tables some of which are linked. Recently there was some addition of fields in one of the linked table which subsequently needs to added to my tables. When I try to add the new field I get the following error "PROPERTY VALUE TOO LARGE" Can anyone assist.
In my case, I get this error when I try to add more than 255 fields to a table. Access tables can only hold 255 fields.
Jun 13 '07 #3

P: 14
some fields consist of name, email , vendor, salary, address etc.
Jun 13 '07 #4

ADezii
Expert 5K+
P: 8,750
In my case, I get this error when I try to add more than 255 fields to a table. Access tables can only hold 255 fields.
Sorry, but there is no way around this restriction that I am aware of.
Jun 13 '07 #5

JConsulting
Expert 100+
P: 603
Hi all,

Quick question, I have a access db that have tons of tables some of which are linked. Recently there was some addition of fields in one of the linked table which subsequently needs to added to my tables. When I try to add the new field I get the following error "PROPERTY VALUE TOO LARGE" Can anyone assist.

Here's a good reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;323657

J
Jun 13 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.