Query runs manually, fails from Outout TO (excel) with "Too ManyFields"

[Phil Smith]

I have a fairly basic select query. It does not rely on any forms or
user input.

If I run it from the 2007 navigation pain, (mispelling deliberate,) or
from the design view, it works great.

If I run it from the 2003 pane, or from the design view, it works great.

If I run it from a macro in 2003, via the Output To, it fails with "Too
Many Fields". When it runs properly, it creates 14 coloums, and 78
records, well within Excel's capabilities.

This is supposed to run via a nightly script.

Please help.

Phil

 

[Steve Schapel]

Phil,

What do you have entered for the Output File argument of the OutputTo
action?

 

[Phil Smith]

Here are all of the arguements for this command.


Query, DailyPromoReport, Excel 97 - Excel 2003 Workbook (*.xls),
s:\sales\reports\DailyPromoReport.xls, No, , 0, Print

 

[Steve Schapel]

Phil,

As a general principle, you should always develop applications using the
earliest version that will be needed for deployment.

It appears you are trying to use Access 2003 to run a macro that was built
in Access 2007.

The OutputTo macro action is different in these two versions, specifically
Access 2007 has an addional argument. I suspect this may be the cause of
the problem.

 

[Phil Smith]

No, the macro was created in 2003, although I added that line in 2007.
I tried to remove that line in 2003 and re-add it, but it made no
difference.

Suggestions as to how I can fix it? It seems ot me that as long as the
database is in 2003 format, it should run under 2003.