To Many Fields defined Message

  • Thread starter Thread starter CL
  • Start date Start date
C

CL

I was running a report that I have been running monthly
for the past 4 months. The query is a make table query
and for the first time ,when I try and run it, it states
Too many fields defined. I know that their is a maximun
amount for fields (256 - If I am not mistaken) and the
number of fields that I currently have in the query goes
up to 150 give or take a few. What can be done to fix
this? Thanks in advance for you assistance. CL
 
Restructure your table to NOT have more than 255 fields.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top