Access 2002 crashes when preview report

[hin]

Hi all.

I have Access 2002 and my database crashes each time I try to preview
any reports. It would crash once every 10 preview, but now it's
happening every time. Here is my computer config:

OS: Windows XP Pro
Ram: 512MB
MS Office: Access 2002.

Here is my sample of the VBA code for the preview button.

Private Sub cmdPreview_Click()
On Error GoTo Err_cmdPreview_Click
Dim stDocName As String
stDocName = "ReportName"
DoCmd.OpenReport stDocName, acViewPreview
Exit_cmdPreview_Click:
Exit Sub
Err_cmdPreview_Click:
MsgBox Err.Description
Resume Exit_cmdPreview_Click
End Sub

Here are some error message I am getting:

Faulting application msaccess.exe, version 10.0.6501.0, faulting
module unknown, version 0.0.0.0, fault address 0x00d9ad84.

Faulting application msaccess.exe, version 10.0.6501.0, faulting
module unknown, version 0.0.0.0, fault address 0x00d9d8c3.

Faulting application msaccess.exe, version 10.0.6501.0, faulting
module unknown, version 0.0.0.0, fault address 0x00d9aac1.

Faulting application msaccess.exe, version 10.0.6501.0, faulting
module unknown, version 0.0.0.0, fault address 0x00d98e1c.

Faulting application msaccess.exe, version 10.0.6501.0, faulting
module unknown, version 0.0.0.0, fault address 0x00d9bdae.

Anybody know how to fix this problem??

Thanks for your time.

 

[Allen Browne]

This is most likely caused by one of the many the Name AutoCorrect bugs such
as:
http://members.iinet.net.au/~allenbrowne/bug-03.html

To rebuild the database, follow the 6 steps for the first symptom in this
article:
http://members.iinet.net.au/~allenbrowne/ser-47.html

 

[hin]

This is most likely caused by one of the many the Name AutoCorrect bugs such
as:
http://members.iinet.net.au/~allenbrowne/bug-03.html

Try it and it's still having the same problem.

To rebuild the database, follow the 6 steps for the first symptom in this
article:
http://members.iinet.net.au/~allenbrowne/ser-47.html

Export it to a new .mdb file and still have the same problem.

 

[Allen Browne]

Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

 

[hin]

On Sun, 19 Sep 2004 00:22:05 +0800, "Allen Browne"

Yes, I had already tried this on both my front and back-end databaes.
Any more ideas?


Thanks

 

[Allen Browne]

FE/BE, eh? Presumably it was the FE you recreated, and then decompiled.

If it was a particluar report that was giving trouble, you could try
exporting a copy of that report with SaveAsText. Delete from the new front
end, and then import with LoadFromText. These are undocumented, but the
arguments are self-explanatory.

Anything else about the queries these reports are based on? Do they contain
subqueries, for example? Do the queries themselves crash if run directly?

 

[hin]

On Sun, 19 Sep 2004 10:10:44 +0800, "Allen Browne"

OKAY!! I finally found my problem. After removing any unused
programs, I found Adobe Acrobat Prof 6.0 was causing the problem.
Once I uninstalled Adobe, I am able to run my reports now without
crashing Access.

Thank you Allen for all your help!

Cheers!
Hin

 

[Guest]

Hi

I have also seen this problem when HP Laserjet 1100 driver is set as my
default printer. In fact I can't preview any report in a MDE without
changing my default printer. This has happened over a few different
computers on Win 98, 2000 and XP with Office 97 and 2000.