We have a Access database 2003.
The feature to export report from Access database failed for few output file types. We are testing in windows 7/office 2007 system.
there are no issues in exporting the report from Access database to the formats PDF, Snapshot, XML and XPS.
The following message is displayed when we are trying to export the report from Access database to the formats Excel 97-Excel 2003 Workbook, HTML, Microsoft Excel 5.0/95 Workbook, Rich Text Format and Text files.
"microsoft office access can't complete the output operation"
code:
DoCmd.OutputTo acReport, stDocName
All this works fine in windows xp/office 2007
Please advice. Thanks