Security on Reports

[Keith]

A2k3, Win XPPro.

I have user-level security set up on my app. All users are members of a
"guests" group to which I have granted read-only permissions to report
queries and open permissions to the reports. User "guest" is a member of
"guests" and nothing else. User "manager" is a member of "guests" so that
they can run reports as well as having membership of other groups for data
editing. No group other than "guests" (and "Admins") has permissions to the
reports or their queries.

So far, so good. All the reports can be run by all users. The problem
comes when I invoke "Analyse it with Excel" - all users except "guest" can
run this feature, but "guest" gets the following error message:

" ... can't complete the Output operation.

The Visual Basic code you entered contains a syntax error or the Output
procedures are not available.

Make sure there isn't a syntax error in your code ..."

Given that all users access the reports through the "guests" group and all
the reports run, why do I get the error for just this one account?

Many thanks.
Keith.

 

[Keith]

Panic over, I discovered that the "guest" user account had become corrupted.
Deleting and re-creating it solved the problem.