Error in Report Print Preview mode

[Tom Isacson]

Quite frequently, we encounter an error when displaying a
Report in PrintPreview mode and then clicking on any of
the page navigation buttons at the bottom of the preview
window.

MS Access doesn't give me an error number or other
information. However, when I attempt to Debug I was able
to get to another screen that showed the following error...

An exception 'Unhandled Win32 Exception' has occured in
MSACCESS.EXE

It seems to happen more often when the Report is opened
via VBA code using a DoCmd.OpenReport. But it sometimes
happens when opening the report directly.

Another interesting twist is that if you do NOT navigate
but simply Print the report after the Preview Window
appears, then we rarely see the error.

Can anyone offer any advice? Is there a way that I can
get more detail on the exact error that is occurring?

Thanks much!!!

The machines in question are all running the following...
Windows XP SP1
Access 2002 SP3
VBA Version 6.04 (according to System Info)

 

[Allen Browne]

First thing to try to uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Then compact the database to get rid of this stuff:
Tools | Database Utilities | Compact
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

If that does not solve the problem, the database is partially corrupt.
You can rebuild it quite easily by creating a new (blank) database, turning
off NameAutoCorrect, and then importing everything from the old one:
File | Get External | Import
General info on recovering from corruption:
http://members.iinet.net.au/~allenbrowne/ser-47.html

You may also want to check that you have the JET 4 SP8, available from
support.microsoft.com (Downloads section). Locate msjet40.dll (typically in
Windows\System32). Right-click, and choose Properties. On the Version tab,
make sure it says 4.0.8xxx.0. The "8" is the important bit.