-
1
- #1
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.
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.