Print problem

[Guest]

I have 2 users sharing a small "back end" .mdb file which sits on a third
machine. User #1 - all is well. User #2 cannot print reports to her local
prtr on her machine. She has other .mdb files on her machine locally, not
shared... rpt's print fine on these other Access files.

She is connected to other "back-end" tables with non-related access
Front-end's .. all print fine. Jus tnot this one. Excel, Word, .txt, etc.
all print fine.

When trying to print from the problem app, her HP bumps ans barks as though
it were going to print, but just won't go (??) Ideas???

 

[Allen Browne]

Hi David.

This one could be tricky to solve. As always, anyone who has a suggestion is
welcome to contribute.

Possibilities that come to mind:
a) a printer/driver problem, or
b) an operating system issue, or
c) a difference in service packs, or
d) a database corruption, or
e) another problem that is being masked somewhere.

(a) could possibly be a suspect, even though other apps and databases print.
If this is the cause, a different printer would work for her.

For (b), make sure this user is logged in as a local computer administrator,
the drive has no chkdsk problems, no unnecessary software, etc.

For (c), locate msaccess.exe in My Computer (Windows Explorer), right-click
and chooose Properties. On the Version tab, see if it is the same version as
on the computer where things work fine. Also locate msjet40.dll (typically
in windows\system32) and check the version. You should see 4.0.8xxx.0 where
the xxx digits don't matter. If you don't see the 8, download and apply SP8
for JET 4 from:
http://support.microsoft.com/gp/sp
or:
http://support.microsoft.com/kb/239114

For (d), make sure the Name AutoCorrect options are turned off (Tools |
Options | General), compact, decompile, compact again, and release an MDE to
give the user. The binary in the MDE cannot corrupt.

(e) could be anything, from bad references:
http://allenbrowne.com/ser-38.html
to spyware/viruses or poorly written software that has hijacked system
calls.

HTH.