Hi all,
I was going to us MS Access for a project but found that it has a field/column limit of 255. Does Base exceed this limit? I could not find any clear answer from the guide, wiki, etc. so I thought I would ask here.
Thank you!
Stick to Access, but choose another database backend. However, running out of columns indicates poor database design.
1 Like
Thanks I understand the column issue and database design…in my case there is a reason there are so many columns since this example isn’t the typical Access examples you see about customer data, orders, etc.
Basically I have scientific samples, each with their own location and contextual info, and then each sample contains plant taxa with counts.
I am attempting to do this with many different locations (sites) for a regional analysis and thus many different taxa.
Do you have any suggestions or places to start with how this could work within the 255 field limit? Thanks.
This is a many-to-many relation, which does not require a new column for each taxon.
See https://forum.openoffice.org/en/forum/download/file.php?id=11250 , relation between persons and things. Each person can be associated to many things and vice versa.
1 Like