configuration or a different problem?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hireagenius - 24 May 2006 16:47 GMT

To Access Heros,
I deployed my new database this week complete with Access security, with the
assistance of this user group.

My problem is this:
I assigned permissions in Access by group and not users. However, some of
the users are having problems.

1) The user gets a "Report Action Cancelled" message when clicking on a
button that opens that report. The user(s) is able to open the forms and
enter data.

2) The main form opens wihout any fields, subforms, or buttons - just a
blank form and no error message.

Troubleshooting the first problem: There are two logins. One for Windows
and one for the Access database We tried his and my Windows login, and, his
and my Access logins in every combination (his Windows login / my access
login; my Windows login / his access login, etc) and could not open the
reports. Then we tried it on a different computer. We both failed on his
computer regardless of which Windows or Access login we used and were
successful on another computer regardless of which Windows or Access login we
used..

I have not attempted to troubleshoot the 2nd problem yet. Out of 22 users in
two groups, I have 5 people with one of the two above mentioned problems. I
am quite certain it is not the access security permissions. Does anyone else
have an idea?
Thank you, Charlie

Reply to this Message

hireagenius - 24 May 2006 22:41 GMT

Hi Heros,
I figured out Problem 2 but still working on Problem 1 if anyone has any
suggestions.
The solution to Problem 2 - you would not have been able to figure out. It
was something I did when I set up a user that is redundant and forgot to do.
It had nothing to do with setting up a user's permissions.
Charlie

>To Access Heros,
>I deployed my new database this week complete with Access security, with the
[quoted text clipped - 25 lines]
>have an idea?
>Thank you, Charlie

Reply to this Message

Keith Wilby - 25 May 2006 10:00 GMT

> My problem is this:
> I assigned permissions in Access by group and not users. However, some of
[quoted text clipped - 14 lines]
> we
> used..

Your windows login has nothing whatsoever to do with MS Access user-level
security so you can eliminate that from your enquiries. If it were a
permissions problem then I would have expected the error message to be "You
do not have the necessary permissions to run... blah blah". The "Report
Action Cancelled" error occurs when the report's "cancel" event fires.
Perhaps you have some code in the report's No Data event and some users try
to open the report with an empty recordset?

Another thing to check is that all users have RWXD permissions to the host
folder, but that's kinda clutching at straws with these symptoms.

Regards,
Keith.
www.keithwilby.com

Reply to this Message

hireagenius - 25 May 2006 18:58 GMT

Keith -
Thanks for the response. Whats weird about it is that the user only has that
problem on his computer and I have the probelm only on his computer.
Everything works fine from a different computer. I am pretty sure I loaded
the same copy on both machines. However, it just occurred to me to reload it
and eliminate that, too. Maybe there was something different about his copy.

Thanks again.

>> My problem is this:
>> I assigned permissions in Access by group and not users. However, some of
[quoted text clipped - 16 lines]
>Keith.
>www.keithwilby.com

Reply to this Message