Open Report Action Canceled

[Guest]

This is a STRANGE one. Users A and B share a computer terminal that has an
Access 2003 front End on the local Drive, connected to a Back End on a server
(Windows). The database works great for User A, but User B cannot get several
reports to open, When she tries, she gets a message box "Open Report Action
Canceled." If she signs on as User A, she can open the reports.

I have not set up any User settings in Access, or any security codes, or
fooled with anything like that. But the ony thinkg I can think of that would
cause the exact same database to work for A but not B is something related to
security settings. Am I on the right track? Any ideas will be greatly
appreciated-- this has even stumped our Tech Services department.

 

[Bob Howard]

Is the report using the default Windows printer or a specific printer? If a
specific printer, does her Windows logon have access to that printer?

 

[Guest]

You're a GENIUS! Turns out user B had e-fax as her default printer. When we
switched her default to a regular printer, the reports opened fine. Thank you!

 

[Bob Howard]

genius: no
shot-in-the-dark: yes

You're a GENIUS! Turns out user B had e-fax as her default printer. When we
switched her default to a regular printer, the reports opened fine. Thank you!

 

[Guest]

Help! I am having a problem. I can run the report on my local machine.
All other machines in the building when I try to run the report it says "Open
report Canceled" I have read every forum to try and find out why. I have
checked print options, linked all the tables, checked margins, headers,
footers. Nothing seems to work. Any help would be nice. Thanks so much

(e-mail address removed)

 

[Duane Hookom]

I didn't notice that you check the Windows Default Printer or module
References.

 

[Guest]

That was the first thing i checked.

I didn't notice that you check the Windows Default Printer or module
References.

 

[Duane Hookom]

You must have forgotten to mention the obvious which sometimes wastes
replies. I made two suggestions and your reply suggested just one. Did you
check the other?

 

[Guest]

I'm sorry, this has got me frazzled---been working on this since 2 am---
yes, I have tried both suggestions that you offered. Any other ideas? any
websites that you can think of that may offer help? I won't mention all of
the ones I've tried but they are several. Thanks for your help

 

[Duane Hookom]

Have you determined if the record source behind the report returns records
on all computers?