Table-Error When Saving

  • Thread starter Thread starter K Ryan
  • Start date Start date
K

K Ryan

I've created a table with about 220 fields. When I try to
save it in Design view now I get "Property Value is too
large. Errors were encountered during the save operation."
I don't know what this means or what to do. Ideas?
 
A row in an Access table can only be 2000 bytes. I suspect that you've
exceeded that limit.

Note that it's extremely rare to need as many as 40 fields in a properly
normalized table: you might want to reconsider how you've designed your
tables.
 
Thanks Doug, for the good advice.
-----Original Message-----
A row in an Access table can only be 2000 bytes. I suspect that you've
exceeded that limit.

Note that it's extremely rare to need as many as 40 fields in a properly
normalized table: you might want to reconsider how you've designed your
tables.

--
Doug Steele, Microsoft Access MVP






.
Click to expand...
 
Back
Top