Error 3190 - Too Many Fields Defined

[Dan]

MS Access 2002 SP3

Building a fairly complex financial forecast model.
Several nested queries. Well into the nested query ran
into Error 3190. Anyone know a workaround other than
writing the data out to a temporary file? (temporary files
are error prone since it would require manual intervention
to run the macro). Does a newer release accomodate for
this? Would hate to not be able to use MS Access...
Thanks!

 

[Douglas J. Steele]

255 fields is still the limit, but the general consensus is that's usually
at least 200 more than required.

You'll have to provide some more details about your design so that others
can comment and perhaps suggest an approach that'll work.

 

[Evan Camilleri]

you can automate the creation of temporary files! i do not see why it hads
to be by a macro !!! I hate macros!

Evan Camilleri