View Single Post
  #3  
Old June 21st, 2007, 11:59 PM posted to microsoft.public.access.tablesdbdesign
S. Spencer[_2_]
external usenet poster
 
Posts: 3
Default "Too many fields defined"

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.

"fredg" wrote:

On Thu, 21 Jun 2007 15:27:02 -0700, S. Spencer wrote:

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail