Group:  Microsoft Access ยป microsoft.public.access.security
Thread: Security has gone wild.

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Security has gone wild.
RTimberlake 02.08.2006 13:43:03
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?

Re: Security has gone wild.
"Joan Wild" <jwild[ at ]nospamtyenet.com> 05.08.2006 00:31:15
RTimberlake wrote:
[Quoted Text]
> 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


Re: Security has gone wild.
RTimberlake 05.08.2006 13:58:01
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.

"Joan Wild" wrote:

[Quoted Text]
> 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
>
>
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net