"Too many fields defined"

[S. Spencer]

I keep getting the above error message. It supposedly means that I am trying
to exceed 255 fields but I only have 212 fields. Any suggestions?

 

[fredg]

I keep getting the above error message. It supposedly means that I am trying
to exceed 255 fields but I only have 212 fields. Any suggestions?

Any table with anything even approaching 100 fields, let alone 212
fields, would appear to be un-normalized.
Access is not a spreadsheet.

Post back with more detail's about your table structure and why you
think you need that many fields in one table.

 

[S. Spencer]

I am setting up a Master Table to be converted to Foundation specific
program. This is the culmination of all the tables that I maintain for our
organization but the company doing the conversion need the information in one
table.

 

[Douglas J. Steele]

While I agree with Fred that no table should have that many fields, try
compacting the database.

Are you sure you have to create a table for the company doing the
conversion? Can you just provide them with a query that joins everything
together?

 

[S. Spencer]

I am researching that but when we had our conference call with them, I
explained what I had very carefully (or so I thought). I was told that they
needed all the information that we wanted converted in one table to make the
conversion clean. I will try the compacting and repair for now.

Thank You!

 

[John W. Vinson]

I am researching that but when we had our conference call with them, I
explained what I had very carefully (or so I thought). I was told that they
needed all the information that we wanted converted in one table to make the
conversion clean.

They may be using the term "table" in a more generic sense than Access does.

Certainly you need all 212 (hopefully not more than 255!) fields in the same
recordset, or the same exported file, or in some form which is usable by the
other program.

It's not obvious that they must be within the same Access Table object in
order to do so, since Access Queries look, act, feel, export, etc. just like
tables in most circumstances.

Be sure it's not just a conflict of jargon!

John W. Vinson [MVP]

 

[scubadiver]

This maybe enlightening:

http://www.mvps.org/access/tables/tbl0002.htm

 

[S. Spencer]

Thanks to everyone for their assistance. I believe that it's a communication
issue between myself and the consultant. I did compact and repair the Master
Table and it did the trick. However, we are trying to get some "face-time"
with this company so that they can better understand what I mean when I say
table vs database.

Thank you again.

 

[Tom Wickerqueer]

if you've seen this message then you shoudl move to SQL Server and Access
Data Projects

 

[BruceM]

Ignore this bitter troll. He shows up from time to time to advocate ADP as
the cure to all problems. Sad to say, when he shows up it tends to last for
a while until he becomes bored or something.