Old report from MS Office 2003

  • Thread starter Thread starter DogmaDot
  • Start date Start date
D

DogmaDot

I recently upgraded to 2007. One report I have tried to run has consistently
"broken" Office. It gives no error message. I have tried to create a new
report
but it still just stops.

Any hints as to what I can try?

DogmaDot
 
Do you actually have any printer installed on your upgraded machine? If
there is no printer, or if there is a fault with the default printer's
driver, Access can't figure out the report layout (since it uses the metrics
from the printer driver.)

If that's not the issue, try getting Access to recreate the report for you.
Steps:

1. Make a back up of the mdb file.

2. Using Access 2003, compact/repair the database. Then open the report in
design view. If it has any code, open the code window, copy the code out
into Notepad and save it. Then set the report's HasModule property to No,
confirming that you do indeed want to lose all its code. Then compact the
database again.

3. Save a copy of the report as a text file: open the Immediate Window
(Ctrl+G), and enter:
SaveAsText acReport, "Report1", "C:\SomeFolder\Report1.txt"
Verify that the file was created. Then delete the report, and compact the
database. Now get Access to recreate the report from the text file with:
LoadFromText acReport, "Report1", "C:\SomeFolder\Report1.txt"
Now paste the code back from Notepad into its module.

Now you can try the MDB in A2007 again.
 
I would try that but the tech had to delete the old 2003 before we could
install the new. I have access to several printers on my network. I'll try
making a different one the default.

Thanks.

Dot
 
Back
Top