Thread: Access Reports Crashing
01-16-08, 16:45 #1Registered User
- 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.GG
On Error Goto Hell Hell: Msgbox("An error occurred, but was sent to Hell. You may continue.")
01-16-08, 19:36 #2Moderator
- 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)