Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Access Reports Crashing

    I nearly quit my job today, but finally I found out what was causing my problems.

    I developed a database application in MS Access 2003 and we use it on XP computers. In has been in use for about 3 years. All of the sudden the reports start crashing the whole application. This was only happening in my development environment. Sometimes I could fix it but not with a consistent method.

    Finally today I realized my default printer was Adobe Acrobat. So I switched back to a physical printer and everything is back to normal.

    I hope this helps someone in the future. Like I said I was about to freak out.
    On Error Goto Hell
        Msgbox("An error occurred, but was sent to Hell. You may continue.")

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    Yes - having a default printer set wrong can lead to strange things with an mdb file. I couldn't even compile my code once as the default printer was set to something which somehow caused the problems when trying to compile the code. After many hours of troubleshooting, once I changed to a new default printer, I was able to compile the code and everything worked ok.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts