Maximun Table Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to increase the maximum number of Colmns allowed in a table. If this
cannot be done, I would like to know how to merge the columns of two tables
to work in the same form.

is this possible?
 
A table can have up to 255 fields in it, which is at least 10 times more
than should be required in a properly normalized database. There is no way
to increase that limit.

Perhaps you can explain what you're trying to do, and someone can suggest
another approach.
 
I have 255 columns used and I need as many as 400 (maybe I am wrong), but I
am building a database for leases that will transfer complete applicant
information to reports (proprietary to the company I work for) (i.e. personal
info, credit info, addresses etc..) if there is a way to use 2 (two) tables
in 1 (one) form that would be great.
 
Thank you,

This helped me alot, although the topic itself did not have the answer
it did point me in the direction where I could find it. All I had to do was
go to "Tools" then "Database Utilities" then "Compact and Repair Database"
and POOF! there was the needed space for my tables.

Thank you once again,

Paul M
 
Your number of "columns" (really, "fields") is /waaaay/ too large &
will undoubtedly cause you serious problems down the track!

As Douglas said, you need to "normalize" your database. You will
bitterly regret it, down the track, if you do not do this properly "up
front".

HTH,
TC
 
Finding the ability to add more fields to a table is kinda like finding the
safety on a gun so that you can turn it off to shoot yourself in the foot.
 
Back
Top