Open Report Action Canceled

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

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.
 
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?
 
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!
 
genius: no
shot-in-the-dark: yes


el zorro said:
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!
Click to expand...
 
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)
 
I didn't notice that you check the Windows Default Printer or module
References.
 
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?
 
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
 
Have you determined if the record source behind the report returns records
on all computers?
 
Back
Top