How many fields can an Access table have?

[DwayneS]

How many fields can there be in one Access table?

I don't usually include 100 fields in one table, but I inherited one and it needs to be expanded.

My client wants me to add more fields and include them in a critical form they use for data entry. What they have works quite well, but there are over 100 fields now.

I don't want to just add to it if I will hit a wall at some point. If I have to rewrite it I want to do it now.

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com

 

[MajP]

255 is the absolute max in a table. But that number is reduced by references to fields such as in indexes.

However, you would have a hard time convincing me that you have something that can be uniquely identified with over 100 fields. My gues your inherited db design is bad and only getting worse.
Unfortunately your stuck with what they gave you. Here is the dilemma, as you said it works. Usually DBs like this do one and only one thing well because they were designed with one specific output in mind. There is absolutely no flexibility in this.

My client wants me to add more fields and include them in a critical form

What they want in a form has no impact to what goes in what table? Do not let the form or report dictate your table design.

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DwayneS]

Thanks for the info and I agree with everything you said. I may just bite the bullet and fix this thing. Someone who first did this tied the form to a table and put everything in one table. It works, but ----

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com

 

[fneily]

Study and apply NORMALIZATION.