Table-Error When Saving

[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?

 

[Douglas J. Steele]

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.

 

[KRyan]

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






.