Reports wont open in preview mode - printer conflict?

[Maver1ck666]

I have a problem with Access 2003 Im hoping you can help me with.

I have created a user database which displays a number of reports based on
statistics a number of users input. When some users try and dislpay the
reports, they get the error message 'The expression After Update you entered
as the event property setting produced the following error: The OpenReport
action was cancelled'.

Here's the strange thing! The database is installed on a number of users PC
and it works for some of them.

I have narrowed it down to the type of printer being installed on the users
PC and specificy the printer model 'HP LaserJet 8100 Series PCL 5e'. If I
remove the printer completely from the users PC and make the image writer the
default printer, the reports will work but as soon as I reinstall it, they
dont. Unfortunately, my company employs over 1000 people and have over 15
different printer models so we cant just change the culprit printers.

The database was built in A03 and comprises of a front-end, back-end and an
..mde which is packaged with a runtime and deployed via an msi using Active
Directory.

Has anyone ever come across this kind of problem before? I have spent ages
searching Google and MSKB to no avail!

Thanks in advance for your help!

Mav

 

[Al Campagna]

Maver1ck666,
You missed some points about this bug... do you have some PCs with the 'HP LaserJet
8100 Series PCL 5e' that DO work with your app?

And, what version of Access you're using, and the what operating system. (I'll bet
it's XP... very printer driver sensitive)

But, anyhoo... the first thing to do is install/reinstall the very latest drivers for
that problem printer, (from the manufacturer's support site) on each system that is
failing.

I've found that the old "run of the mill" cheapo inkjets usually run fine... it's those
high capacity, bells and whistles, office network printers that cause compatability
problems.

Also, if you do have some PCs that work with that printer... compare the printer
configuration setups.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Maver1ck666]

None of the PC's with the 8100 installed can display the reports but the
rest of the database works fine.

I am using Access 2003 (11.6566.8122) SP2 with XP SP2. All regulary patched
with the latest MS releases.

Know what you mean regarding the types of printers. All our older HP 5si
printers work fine and all the fancy brand new 8100's dont!

Thanks for the help Al Campagna, its much appreciated.

 

[Al Campagna]

Maver1ck666,

I am using Access 2003 (11.6566.8122) SP2 with XP SP2. All regulary patched
with the latest MS releases.

It's not the operating system that needs updating, it's the printer driver. Go to the
manufacturer's support page, and download and install the very latest drivers that you
find there. Be sure to match the model exactly.
Until you do that, you may be whizzing into the wind...

Are you referring to the HP LaserJet 8100?
http://tinyurl.com/2ryg9l
Also, as you drill down towards your particular model, you see on page...
http://tinyurl.com/3ypqg5
under Useful Links... a "Check my Driver" option. Didn't try it myself, but worth a try.
I'd still download and reinstall the driver regardless.

Also search the web on your "8100" and "printing problems" and "Microsoft Access"

Because the 8100's all fail, you know it's not Access, and if the updated driver
doesn't cure the problem, I would suggest contacting the manufacturer for support, or...
perhaps your vendor.

and all the fancy brand new 8100's dont! (Thus spake Zarathustra!!) :-D

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Maver1ck666]

Yeah cheers for that. I ended up looking through the device details and
noticed that the only difference was the 8100 series' rendering mode was set
to automatic whereas all the other printers were set to 'send graphics as
vector'. I just changed this on the PC's that weren't working all everything
now works perfectly! WooHoo!!!

Thanks again for your help!

Mav