Security Problem

[PeterWieland]

After many late nights, I finally thought I had got the hang of security, until I made a self-modifying form!

I have a form that displays a different sub-form dependant on the data selected. When users with Open/Run permissions on the form run it, they get a message that they do not have permission to modify the form. The only way round it is to give them Modify rights. This then defeats the object of protecting the database!

I assume there must be a way round this, but I can't figure it. Any one have any ideas?

Pete

 

[The_Doc_Man]

It depends on how you are doing it, but one approach that many folks have used successfully is to just alter the visibility of each part that they don't want seen.

I don't understand why you would have gotten that message unless you were trying to build a control or sub-form dynamically, or unless you were trying to dynamically link an existing sub-form to the parent.

Things you can safely do from VBA without counting as "modifying" the form:

change visibility of form/control
open/close an existing sub-form
change enabled-state of control
change position/size of control AFTER it has been displayed (for controls like rectanges & lines)
change SQL-based recordsource & filters

 

[PeterWieland]

Thanks Doc,

I was dynamically linking existing sub-forms. I have just tried it by putting both sub-forms on the parent, one on top of the other and changing the visibilty as required, and it works.

Pete