Exporting Report to Snapshot - ODBC Error

[Guest]

When I am exporting a report from Access 2003 to Snapshot Viewer, I am
getting an ODBC Error when it is almost finished, and if I click on ok, the
message goes away and if AutoStart is selected, the report comes up in
Snapshot Viewer no problem. This issue just started today and has been
running fine for months.
Any thoughts?

 

[SA]

You may be running into a time out issue with the query underlying the
report (i.e. the data set combed probably has increased.) Take a look at
increasing the ODBC time out value for the report's underlying query in the
query properties.

 

[Guest]

Unfortunately I had already tried that, moving the timeout to 120 and still
getting the same error. I'm told nothing has changed in the programming to
change anything affecting this query.

I'm hoping there is something else I am missing on this. Any suggestions are
appreciated.

Thank you Steve

 

[Guest]

Try changing the timeout to 0, that prevents from checking, also if you are
filtering the information for big amounts of data it could help to have an
index on the fields you are using to filter the information.

 

[Guest]

Well, that helped, but not with the issue with the ODBC error, the report
runs much faster, I also changed the Recordset Snapshot to Snapshot, and
still get the error after the report has been run and once I try to export.

Is there any way of bypassing the report coming up in access to directly
come up in Snapshot Viewer?

Thank you for your assistance, its greatly appreciated.

 

[Guest]

Try this in a vb module:
function Create_SNP()
DoCmd.OutputTo acOutputReport, "ReportName", acFormatSNP,
"C:\MyReport.snp"
end function

Replace your report and file names