Print preview closes Access

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

Guest

I have a DB created in Access 2000 (SP3) and moved to a PC with Access 2002
(SP3). All reports in the DB open in Preview mode. One report when opened on
the Access 2002 system immediately closes Access with no message but still
works OK on the Access 2000 system. Attempting to open the report in design
view has the same result (on the Access 2002 system).
All other reports in the DB work OK including others using the same table as
the failing one. (Different queries of course).
This appears to be a similar problem as defined in KB article 814093 for
Access 2000 but this is not described in KB for Access 2002
Will be truly grateful for the solution
 
This sequence should get you going:

1. Use Access 2000 to decompile the database. Enter something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

2. Uncheck the boxes under:
Tools | Options | Name AutoCorrect
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

3. Still in A2000, open the report in design view. Choose File | Page Setup,
and make sure the report is set for the default printer (not a specific
printer). Save and close the report.

4. Compact the database.

5. Now use Access 2002 to create a new (blank) database:
File | New

6. Turn off Name AutoCorrect in the new database.

7. Import everything from the old database:
File | Get external | Import

8. Open a code window, and set just the references you need. More info:
http://members.iinet.net.au/~allenbrowne/ser-38.html

9. Still in a code window, check that the database compiles:
Debug | Compile.
 
Back
Top