Access crashes when export report

Harry Shmedlap

Registered User.
Local time
Tomorrow, 01:41
Joined
Aug 9, 2005
Messages
51
When I export my report to rtf format Access crashes with the familiar "Microsoft Access has encounterd a problem and needs to close" message.
Any ideas?
Thanks in advance
 
1. Re-compile for errors
2. Compact & repair

???
ken
 
is this from a split d/base (Fe/Be)
if so are you doing this from the server side or the local side
try it from the local side (servers sometimes get iffy doing this)

g
 
Compact & repair - DIDN'T HELP.
Re-compile for errors - WHAT DO YOU MEAN?

NO IT IS NOT A SPLIT DATABASE. IT IS A VERY SIMPLE STAND-ALONE DATABASE.

When I run the Export - I see it going through the pages and at around page 24 it crashes.
 
How many pages in total ??

rtf is not that great a piece of software - you might be better of pdf-ing it
 
The report is 27 pages long.
Snapshot works fine - thanks.
By "PDF'ing" it do you mean: while in the report's Print view, to print the report using a PDF-writer driver? Well if so, then that works as well. (I use PDF995). - thanks.

In either case I prefer the rtf format because I want to append several reports together. (Each report is generated from a different query, and each report has different fields).

One more thing. Sometimes it DOESN'T crash! In fact it may have to do with the source file. The database uses linked tables from an Excel workbook somewhere else on the company network. I noticed that when the workbook is open, the report generation - when it works - is much slower. It may be that there is a timeout in the rtf generator and when the network is slow, rather than reporting that or simply waiting, Access simply shuts down.
Perhaps those other drivers better handle a network timeout - if that indeed is the cause.
Right now I can't get the crash to happen, so I can't know for sure. Perhaps I'll try this again tomorrow at the peak network useage time.
 
The next time it crashes you may want to make an immediate back up copy of the mdb to use for testing so that you can do further research, for example there maybe something in the data itself causing the crash...

:)
ken
 

Users who are viewing this thread

Back
Top Bottom