Col Limit in a table

  • Thread starter Thread starter SITCFanTN
  • Start date Start date
S

SITCFanTN

What is the maximum number of columns I can safely have in a single table in
Access 2003?

Thank you
 
As Roger and Allen have correctly noted, the maximum limit is 255; however,
you probably can't, nor should, have anywhere near that many.

There's another limit to contend with and that's 2000 characters per record
(excluding Memo, OLE and Attachments). That's only about 8 characters per
field on average.

Also properly normalized data seldom requires over 30 fields per table. The
data may need multiple tables though which are linked to each other.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit on number of fields in MS Access forms 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Saving File in Access 2007 3
How many MEMO fields allowed in a table? 16
Table Row Limit Size? 14
Number of characters in a table name 11
Maximum Columns in Table 10

Back
Top