Access 2002 Report error

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

Guest

Hey everyone!

If anyone has a solution for this problem, i would be so grateful. We have a
report that is heavily programmed and utilized within my company. When our
Network Admin replaced the printer that the report used as its default, it
suddenly crashes access every time someone tries to access it.

I need to find a way to re-assign the default printer without using any of
the printing options (since it crashes the system every time). Is there any
way for me to fix this?? Thanks!
 
Hi Mike.

Couple of possibilities. It's probably a corruption of the mdb, but could be
related to permissions or the printer driver.

1. Make another backup copy so you get multiple chances at fixing it.

2. Check that you have at least SP2 for Access 2002 (see Help | About - SP3
is available), and at least SP7 for JET 4 (SP8 is available). For the JET
one, locate the file msjet40.dll (typically in Windows\system32),
right-click and choose Version. The minor version number should start with a
7 of 8, e.g. 4.0.8xxx.

3. Once you have the right version, make sure that the Name AutoCorrect
boxes are unchecked under:
Tools | Options | General.
One of the many bugs associated with "Name AutoCorrupt" is printer problems.
See:
http://members.iinet.net.au/~allenbrowne/bug-03.html

4. Decompile a copy of the database by entering 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"

5. Compact again.

If you are still stuck at this point, try the undocumented command to export
the report to a text file:
SaveAsText acReport, "Report1", "C:\report1.txt"
The delete the report, compact the database, and load it back from the text
file:
LoadFromText acReport, "Report1", "C:\report1.txt"

It could also be a problem with the new printer driver. Do you have the
permissions to go to Control Panel | Printers, and choose your old printer
as the default? (The printer does not have to be physically present.) Then
try previewing the report. This might let you work around it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top