Form/Subform Security

[lloydmav]

I have a form and a subform. On the mainform I would like to stop the records from being edited. So I have stopped editing, additions and deletions. However I would like the details from the subform to beable to be edited. However the subform has the same "Allow" properties as the mainform.

Is there any way of getting around this so that the main form cannot be edited but the subform can?

Thanks

 

[Autoeng]

You are probably going to have to use Access Security to overcome this. With security in place you can set the permissions for the subform separately from the main form.

Perhaps someone can come up with a code way around this but I don't think it looks too promising.

If you are interested in the security option I urge you to read as many posts as you can on the subject because it can be quite daunting.

Autoeng

 

[lloydmav]

Yeah I have only just started developing this database. I intend to use the security tool but I wasn't going to do this until I had finished the database. I intend on having usergroups and access rights for each user. I was kinda hoping I could set alot of the rights that aren't user specific before applying the security tool.
I've researched the security wizard etc quite alot and will make backups before I attempt it. Have you come accross any major problems with it?

Can the security tool definately set the main form and sub form seperately?

 

[Autoeng]

Yes the security can separate the form from the sub form permissions. I have this in several of my db's. Remember that a subform is really a standalone form that is inserted into another.

If you are careful you shouldn't have any problems with the security setup. Just take your time and learn as much as you can beforehand. If you need any help just post.

Use groups to set your permissions as it will save you a lot of time versus setting up permissions for each individual person. I recommend downloading the security add-in from Microsoft as I think it is a better interface for setting the permissions than the security manager that is default with Access.

Good luck,
Autoeng