View Single Post
  #5  
Old June 22nd, 2007, 12:19 AM posted to microsoft.public.access.tablesdbdesign
S. Spencer[_2_]
external usenet poster
 
Posts: 3
Default "Too many fields defined"

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!

"Douglas J. Steele" wrote:

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?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"S. Spencer" S. wrote in message
...
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?