Access 2003 Runtime will not generate reports

[msrichards]

Have an MS Access ADP project running on hundreds of machines under MS Access 2003 Runtime. On a particular client's machine it worked fine up until last week. After installing MS updates last week, NO reports show. All work in the Report_Open event is done, then the report closes itself before display. The machine is Vista Home Premium, and has Office 2007 on it. No error message is shown, and there is nothing in any of the Windows Event logs. Any ideas would be greatly appreciated!

 

[HiTechCoach]

Is there a printer driver installed?

 

[msrichards]

Is there a printer driver installed?

Yes, there is. I suppose, though, that I did not verify that it actually prints. I will check the driver and test that tomorrow. Thanks. Will post results.

 

[msrichards]

Yes, there is. I suppose, though, that I did not verify that it actually prints. I will check the driver and test that tomorrow. Thanks. Will post results.

I verified that the printer was installed properly, so it is something else...

 

[Alisa]

I haven't seen this particular problem, have you checked to see if there are any new hotfixes out? Also, you could make a test mde with a very simple report and see if that will open on that machine. If it doesn't, then you know something is wrong with the environment. If it does, there is something specifically going wrong in your program.

 

[msrichards]

I haven't seen this particular problem, have you checked to see if there are any new hotfixes out? Also, you could make a test mde with a very simple report and see if that will open on that machine. If it doesn't, then you know something is wrong with the environment. If it does, there is something specifically going wrong in your program.

That is an excellent suggestion. I have packaged up a test mde and will get the client to try it out tomorrow. If it works, you are right: it must be something in my program and not a system issue. Thank you.

I have not found any hotfixes for this problem.

 

[msrichards]

Well HiTechCoach your instincts were right. The default printer was a LaserJet 1020 - had all the right printer drivers works fine, etc. I changed the default printer to a Multifunction HP printer they happened to have and now Access works great. Re-installed the LaserJet 1020, downloaded and installed drivers, set that back to the default, and again we have the error. If we change the default back to the Multifunction printer, the reports work. If we preview a report, then change the printer to the HP LaserJet 1020 through the print dialog, it prints fine. So, there seems to be a problem between Access's report engine and the driver for the HP Laserjet 1020. Anyone every hear of anything like this before? Or does anyone have a Laserjet 1020 and it works with Access? Weird....