Security Permissions and Subforms 1

[tigercrap]

Hi All,

I am currently assigning read only permissions to users in the database and when the users login the subforms are not shown. I set the applicable tables to Read and the subforms to Open/Run. When i change the permissions to Insert or Update the subforms start showing again.

Any help will be greatly appreciated!

Thanks
Tim

 

[LittleSmudge]

Is the rectangle where the sub form should be WHITE or is it the same colour as the sub form background should be ?


Do you have data that should show up in these sub forms - or are they 'data empty' ?


If the first answer is not White and the second is 'data empty' then you are getting what I'd expect ( Or rather your description of what is happening is as I'd expect it to be described.



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[tigercrap]

Thanks for the reply!

The rectangle is the same colour as the background, as if the sub form is not there.

The subforms will be used to input data.

Thanks again for your help!

Tim

 

[LittleSmudge]

If there's NO data and you don't have permission to add data then you'll see the empty form - devoid of all controls etc. - Just as you describe.

Try it with some data in and I think you'll get what 'you' expect.



G.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[tigercrap]

Thanks so much! That was it, just needed some data in there.

I have another huge problem and very dumb of me. I allowed other people to access the file on my computer, well the Secured work group information file was deleted and now i am completely locked out. Any ideas.

Thanks

 

[LittleSmudge]

Get it back off last night's backup ?

Recreate it ?
( you did write down the WID, PIDs etc - DIDN'T YOU ??? )









G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[tigercrap]

I finally got it! I found the WIF information i wrote down, but i lacked the users PID's etc.

Thanks Again for your help!