Microsoft KB Archive/61623

Excel for OS/2: Protection Violation from Printer Setup Dialog PSS ID Number: Q61623 Article last modified on 06-23-1993 PSS database name: W_eXceL

2.20

OS/2

Summary:

A protection violation can be generated from Excel for OS/2 when the Setup button from the File Printer Setup dialog is chosen if the OS2SYS.INI file contains incorrect or incomplete information.

This error has been most often reported when setting up the printer associated with the LPT1Q. The entry on the File Printer Setup dialog box will usually look like “LPT1Q on LPT1Q.”

More Information:

The setup of OS/2 1.2 installs the LPT1Q by default. Any printer associated with this spooler queue will appear in Excel as LPT1Q on LPT1Q.

Solution
Informal testing with this problem has shown that by deleting the LPT1Q and then adding it back, the problem doesn’t occur. Try these steps to eliminate this problem:


 * 1) Close Excel.
 * 2) Open Print Manager and select Setup Queues.
 * 3) Select Add on this dialog. Type “BOGUSQ” (without the quotation marks) into the Name box. Make sure the Queue driver is PMPRINT, no printers are selected in the scroll box, and that None appears in the Printer Driver box. Choose Add on this dialog and OK on the Queues dialog.
 * 4) Select Setup Application Defaults. Select BOGUSQ as the default queue and select Set.
 * 5) Select Setup Queues, select LPT1Q, and select Change. Cancel any printer that may be highlighted in the scroll box and make sure None appears in the Printer driver box. Select Change.
 * 6) Select LPT1Q and Delete. Answer Yes to the alert message. The LPT1Q has now been deleted along with the information in the OS2SYS.INI file.
 * 7) Choose Add on the Queues dialog. Type LPT1Q into the Name box, make sure that PMPRINT is the Queue driver, select the appropriate printer name from the scroll box and proper printer driver in the Printer driver box. Choose Add on this dialog and OK on the Queues dialog. The LPT1Q has now been added back and the correct information written to OS2SYS.INI.
 * 8) Select Setup Application Defaults, select LPT1Q as the default, and select Set.
 * 9) Select Setup Queues, select BOGUSQ, and select delete.
 * 10) Open Excel and choose Printer Setup from the File menu.
 * 11) Select LPT1Q on LPT1Q and select Setup. The appropriate printer setup options dialog should now be displayed.

This is a problem that has been reported both with IBM OS/2 1.2 Standard Edition (SE) with a CSD level of XR04020, and with Extended Edition (EE) with a CSD level of WR04053.

Microsoft is researching this problem and will post new information here as it becomes available.

Copyright Microsoft Corporation 1993.