Column limit

[Guest]

What is the maximum number of columns an Access database Table will allow?

 

[Guest]

in the help file you can fin the full specifications of access - search on
specifications

255 fields by the way

 

[Ken Snell \(MVP\)]

255. However, if you find the need to build a table with more than 30 - 40
fields, then it's very likely that you're building a non-normalized
database.

 

['69 Camaro]

Hi.

What is the maximum number of columns an Access database Table will allow?

Theoretically, up to 255 columns. However, you won't be able to fit in more
columns than can fit into about 4,000 to 4,050 bytes, because no record in
the table can exceed the table's data page, which is 4 KB (with Memo fields
and OLE data types being the exception, because those aren't stored in the
same data page as the rest of the columns in the record). But if you're
asking for the maximum number of columns, then be advised that you should
have a maximum of about 30 columns, 50 at the outside. Otherwise you're
building a spreadsheet, not a table, and you need to normalize the table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Graham Mandeno]

The maximum is 255.

However, I suggest that if the number of columns in your table is more that
about 30-40 then you probably have some serious design problems.