Table building, column word or space limitation

[mattpv]

Is there a space limitation in the columns under table building? If so is there a way around it, I have run into this problem. Please help. Thanks

 

[JLSigman]

I think if the data type is text, the limit is 255 characters. If you need something bigger, consider making it a memo, which gives you unlimited space.

-jenn

 

[Maquis]

I believe you can only have 255 columns in a table. However, if you are coming anywhere close to that number, then you really need to sit down and re-think your table structures. Start breaking your data down into different tables and/or combine multiple fields into 1 field.

Take a look at your data and see where it can logically break down into different areas. Those can then be stored in different tables and related back to each other using Primary key relationships. Maq B-)
<insert witty signature here>

 

[mattpv]

Thanks for the help people