Security issues between groups

[mafhobb]

There are two tables and two forms. One table is secured to be used by one security group and the other one by a second group.

The problem comes when I need the 2nd group to update one, and only one field in the 1st group's form/table. To do this, I have one unbound text box and a macro on a button that uses the setvalue function to equal the value of the text box in the 2nd group's form to the value of the text box in the first group.

With all the security removed, the macro works well and it updates everything well, but when security is enabled, I get the message "This recordset is not updateable"

Obviously this has something to do with the tables permissions. Is there any way around this problem that does not involve giving full control of all table to the 2nd group? Can the macro be modified to override security once it is activated and then go back to normal?

Thanks

Mafhobb

[Guus2005]

Perhaps using a macro (which i never use) you can temporary add a security group to the user. This security group contains only this specific security feature. When done simply remove this group from this user.

[mafhobb]

This sounds like an interesting proposition...Any idea on how to do it with a macro, or any other means?

mafhobb

[Guus2005]

did you search the internet? I would have to do so to answer your question. I'd rather liked you did.

[Guus2005]

Ok, i did it. Create a new workspace:

Set HighLevelSecurityWorkspace = CreateWorkspace(Dummyname, Dummyuser, password, type)

Using this workspace you can do anything you want if the DummyUser belongs to a specific group designed for this purpose.

HTH