This might work for us. I would like to test it.
There is an added complication - isn't there always.
File are added by the initiator. Depending on values in the form other people (approvers) are given access (DBXL + contidional formatting). (This is a complex formula/process with 250+ permutations).
If the files are considered sensitive only the approvers can see them but not edit/delete. If the files are "normal" then anyone opening the form should be able to see them but not edit/delete them.
I am concerned about "unloading" the files into Sharepoint as the permissions which would need to be set on the SharePoint library would be very complex - Even if opening the infopath .xml is slow I know that the conditional formatting will stop the sensitve items being visible to the non approvers.
Catharine