Security has gone wild.

2 Aug 2006 1:43 PM

RTimberlake

I am having some huge problems with my security.
For some reason security and all user names and passwords work fine on my
computer. However, when I go to my users computers things aren't working
correctly. The users can only see the form header of each form, the detail
section is not visible. And I have a query that is used for data entry and
the data entry portion is not working. It will show past entries, but will
not allow you to enter new ones. Why is this happening. Everything is stored
on our network. Everyone, myself included, is accessing the same files. Why
does it work on my computer and not on anyone elses?

5 Aug 2006 12:31 AM

Joan Wild

RTimberlake wrote:

> I am having some huge problems with my security.
> For some reason security and all user names and passwords work fine
> on my computer. However, when I go to my users computers things
> aren't working correctly.

Are these computers using the same workgroup file you used to secure the
mdb?

The users can only see the form header of

> each form, the detail section is not visible.

Does the detail section have a subform in it? Do users have Open permission
on the subform? Do they have at least read data permission on the record
source of the subform?

And I have a query that

> is used for data entry and the data entry portion is not working. It
> will show past entries, but will not allow you to enter new ones.

Do users have insert permission on this query? If the query isn't set to
RWOP (run with owner permissions), do the users have insert permission on
the underlying tables?

--
Joan Wild
Microsoft Access MVP

5 Aug 2006 1:58 PM

RTimberlake

Thank you for your response. I think I have figured out the problem. We
placed all of the databases that feed into our main db in a hidden folder.
Somehow the folder was marked read only. As a result the users could not
access any of the data. When I removed the Read only status things seemed to
work them selves out. Thank you for your time and your comments.

Show quoteHide quote

"Joan Wild" wrote:

> RTimberlake wrote:
> > I am having some huge problems with my security.
> > For some reason security and all user names and passwords work fine
> > on my computer. However, when I go to my users computers things
> > aren't working correctly.
>
> Are these computers using the same workgroup file you used to secure the
> mdb?
>
> The users can only see the form header of
> > each form, the detail section is not visible.
>
> Does the detail section have a subform in it? Do users have Open permission
> on the subform? Do they have at least read data permission on the record
> source of the subform?
>
> And I have a query that
> > is used for data entry and the data entry portion is not working. It
> > will show past entries, but will not allow you to enter new ones.
>
> Do users have insert permission on this query? If the query isn't set to
> RWOP (run with owner permissions), do the users have insert permission on
> the underlying tables?
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>