Access Printing Error

[InsaneProgrammer]

I am using an Access 97 database on a Windows 2000 machine and get the following error when I try to print a specific Access report.

"There isn't enough free memory to update the display. Close unneeded programs and try again."

The report prints fine but the message always comes up. I have increased the virtual memory but that didn't work. The report is printed from a button that has the following code.

Private Sub cmbPrint_Click()
On Error GoTo Err_cmbPrint_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

DoCmd.PrintOut acSelection, , , , , acPreview


Exit_cmbPrint_Click:
Exit Sub

Err_cmbPrint_Click:
MsgBox Err.Description
Resume Exit_cmbPrint_Click

End Sub

The problem doesn't occur on Windows NT 4.0 machines. Any ideas?

 

[thornmastr]

This is common if you are running A2K and have not installed the latest SR.

I have had the error using A97 one time and that was due to a corruption problem. you might try creating an empty db and copying everything from the error db into the new db. That did solve the problem for me. Perhaps it will work for you.

Good Luck. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com