Security has gone wild.

[Guest]

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?

 

[Joan Wild]

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?

 

[Guest]

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.