Reports stopped using bad default printer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using MS Office Professional 2003. After creating an Access Report I
changed the default printer to one that WAS NOT a valid printer on the
network. Now, the Access Report will NOT execute or open in design mode. The
work-around has been to change the default printer to Microsoft Office
Document Image Writer then when I want to print the report I change the
default printer back to a valid printer and it works.

I uninstalled and reinstalled Office Professional but no joy. BTW, all other
databases that I have work just fine with the valid printer as default
printer.

Other than recreate the database is there a permanent fix I hope?!
 
Suggestions:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Make a backup copy of your mdb file.

4. While your printer is set to the one that works, open the report in
Design view, and make sure it is set to Default Printer under File | Page
Setup.

5. Export the report to a text file using this undocumented command:
SaveAsText acReport, "Report1", "C:\Report1.txt"
Delete the report.
Compact the database again.
Then import the report again from the text file:
LoadFromText acReport, "Report1", "C:\Report1.txt"
 
Well, I first made a copy of the mdb file first. Then performed the first 3
steps. The 4th step says to open the report in Design view--BUT IT DID NOT
OPEN. Any alternative things to do here? Thanks!!!
 
Mike, you indicated that you were able to get the report open in design view
in your old database? If so, try the SaveAsText from that database. If the
report is corrupt, that could fail, but give it a shot.

If it works, delete the bad report from the new database you created. Then
compact. Then try the LoadFromText into the new database.

I also want to verify that all your other reports work fine, so it is just
one corrupt report we are trying to rescue.
 
Allen,
This problem affects ALL Reports in ALL databases I can access. However,
this database is on our network drive and anyone else accessing this database
from their workstation has the same problem as I do-they/I cannot open the
database in design mode/execute the report. When they/I change the default
printer to the "Microsoft Office Document Image Writer" then all is okay to
update. But at the time of printing, the valid printer MUST be set as the
default printer in order to print.

Somehow the database is corrupt in some manner but this is mystry!!

Thanks,
Mike
 
Back
Top