Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Property value too large in table 1

Status
Not open for further replies.

mfd777

Programmer
Sep 21, 1999
53
IE
Hi All,
I'm trying to amend a table in access 2000. It has roughly 140 fields in it. A lot of them are lookups to another table e.g.
cargo1, cargo2 etc..

I need to add another 20 of these fields but it is comming up with an error:
"Property value is too large". I don't think I have exceede the max numberof fields on a table but perhaps I have exceeded table definition length? Any ideas would be greatfully accepted. Unfortunatly normalising the database is not an option. these fields need to go into this table. I think they will save as normal text fields but not lookups.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top