Number of fields in a table are limited to 255

  • Thread starter Thread starter Massimo Belgrano
  • Start date Start date
Fortunately, yes.

That's about 4 times as many as you could ever need for a correctly
normalized data design.
 
allen i dont agree with that.

there are perfectly legitimate reasons to have hundreds of columns.

nothing is proper and throw your theory out the window. it was all
written by a bunch of old stodgy ibm folk anyways
 
allen i dont agree with that.

there are perfectly legitimate reasons to have hundreds of columns.
Click to expand...

I am sure there are. I have never seen an example. I have seen many
examples of poor design with far fewer fields. (we call them fields now)
:-)
 
joseph

you should be teaching theory not writing databases kid

nothing is ever properly normalized

and having a useable database; and a proper database are 2 totally
opposite things
 
joseph

you should be teaching theory not writing databases kid
Click to expand...

Thanks, I have not been called a kid in 30 years, and that was only
because there were older people on the job.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Linking Access to selected fields in a large external table 1
Field count limit >255 in Access > 2003> 11
Upsizing and Limit of number of fields 2
Linked Table 3
Linking to tables with greater than 255 fields/columns 7
More than 255 Fields in a Table 17
ADO help : 255 Character limit on memo field....!??!?!? 4

Back
Top