Reports Not Running On Certain Machines

[Chris Guimbellot]

Hello,

Access 2000. I have an Access MDB that serves as a front end while the
tables are stored in my SQL Server. Anyway, when I run reports from the
switchboard from my computer, everything seems to work fine. However, when I
go to a user's desk and run the report from there, I get the error "There
was an error executing the command". I have had this problem before and
followed the directions here
(http://groups.google.com/groups?selm=es5AJkglAHA.2232@tkmsftngp05), also
a question I asked, pertaining to the references. This time, it did not
work. Any ideas would be greatly appreciated. Thanks,

Chris

 

[Chris Guimbellot]

To all,

I found the problem. I used the technique in article
(http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=024401c34c
a3%2402ae8d80%24a501280a%40phx.gbl), thanks Jeff, to find that when it was
opening the report, it had to call tables to which the account did not have
permissions. Following Jeff's suggestion, the error message coming back said
"ODBC Call failed 3146" thus simplifying what the problem was.

Chris