Running a Report

[Bonni Wilbourne]

I have multiple users that run reports off of my database - each of them have
security to run the reports. Only one user gets an error when trying to run
reports - The error message says "there was an error executing the command"
What is causing this?

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

 

[Bonni Wilbourne]

I have access 2002 -
It's not something I am trying to do - rather it is something that is
happening when one of my users is trying to run a report - they are getting
an error.

 

[John Vinson]

I have multiple users that run reports off of my database - each of them have
security to run the reports. Only one user gets an error when trying to run
reports - The error message says "there was an error executing the command"
What is causing this?

Presumably an error occuring while executing the command... :-{(

Without more information it's impossible to be sure. Does the user
have permissions to the data in all the tables? If you step through
the VBA code (which I presume is being used to launch the report),
where is the error message triggered?

John W. Vinson[MVP]

 

[Jeff Boyce]

Disregard the "you can't do this" response. It is either SPAM or something
worse. Follow the link at your own peril!

The person posting the response has used several different aliases, and is
now representing him/herself as an MVP.

Regards

Jeff Boyce
Microsoft Office/Access MVP