Table size

R

Rickkan

Is there any particular number of columns in a table that, when reached or approached, impairs the functionality of Access? Currently, the largest table in my database has about 50 columns, but I may want to expand this particular table to 150 columns. Would there be any reason that expansion to this size would not be advisable

Thanks for any response

Rickkan
 
A

Allen Browne

Access will cope with it, but it is probably not a good design.

Look at the columns you propose. Any repeating ones? They should definately
be in a related table.

Having 150 attributes to track is probably very common, but having 150
different types of attributes to track is extremely unusual. There will be a
better way to break this data down.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Rickkan said:
Is there any particular number of columns in a table that, when reached or
Click to expand...
approached, impairs the functionality of Access? Currently, the largest
table in my database has about 50 columns, but I may want to expand this
particular table to 150 columns. Would there be any reason that expansion
to this size would not be advisable?
 
Top