I've got a DoCmd.OutputTo command within a macro.
It's about the 8th procedure within the macro.
For some reason the query the macro is supposed to output fails when the output is attempted.
I have since tried this on another PC and it worked, does anyone have any ideas on what may be wrong on the other PC?
Do you have access to the output path on both computers? If it is output to a network drive, do both computers have the same permissions to that drive? If it is output to a local path, does that path exist on both computers? If the output command is directing the output to D:\Data\transfer.xls and one of the computers does not have D:\Data, then the output will fail on that computer.