Too Many Fields Defined Error

[Steve]

Hi,

I have a large report running on my Access 2000 database that calls a stored
procedure from our SQL Server. After making some recent amendments, I've
started to get a 'Too many fields defined' error when I try to run it.

There are only around 90 fields that are generated by the stored procedure &
in total just 226 text boxes / labels on the report (although most of these
contain IIf statements) so I'm within the 255 maximum. I've tried compacting
the database and copying the fields to a new report but don't seem to be
able to fix things. I'm starting to think that I may be around the '754
controls & sections' that I can add 'over the lifetime of the report' (some
of the textboxes have numbers in the 700's). Any ideas as to how I can
tackle this ? I thought that copying the fields to a new report was meant to
solve the majority of these problems - has anyone any experience with this ?

Thanks

Steve

 

[Mike Painter]

Hi,

I have a large report running on my Access 2000 database that calls a
stored procedure from our SQL Server. After making some recent
amendments, I've started to get a 'Too many fields defined' error
when I try to run it.
There are only around 90 fields that are generated by the stored
procedure & in total just 226 text boxes / labels on the report
(although most of these contain IIf statements) so I'm within the 255
maximum. I've tried compacting the database and copying the fields to
a new report but don't seem to be able to fix things. I'm starting to
think that I may be around the '754 controls & sections' that I can
add 'over the lifetime of the report' (some of the textboxes have
numbers in the 700's). Any ideas as to how I can tackle this ? I
thought that copying the fields to a new report was meant to solve
the majority of these problems - has anyone any experience with this
?

There is a knowledgebase article about this problem that deals with forms
that are currently within the limits but only because other fields were
deleted to get there.

You might try cutting and pasting from the problem report to a blank new
one.

 

[Steve]

Thanks Mike

You might try cutting and pasting from the problem report to a blank new
one.

I'd seen that posted elsewhere & have already given it a go (although copy &
paste rather than cut) -alas it doesn't help. I'm beginning to think that
I'll have to remove one of my groupings (there are 4 plus the details) &
that there's a bug in Access 2000 that doesn't count fields in pass through
queries or something.

I might try & find a PC with Office 2003 on at work & see whether that
helps.

Thanks

Steve

 

[Tom Lake]

Hi,

I have a large report running on my Access 2000 database that calls a
stored procedure from our SQL Server. After making some recent amendments,
I've started to get a 'Too many fields defined' error when I try to run
it.

Try compacting the database. That will eliminate all the deleted fields.

Tom Lake

 

[Steve]

Thanks Tom

Try compacting the database. That will eliminate all the deleted fields.

Already tried that too - I'm just about ready to give up !

Steve