Hello All,
I've been working on this issue for 2 days now and can not come up with a good solution, please someone point me in the right direction...
When using VB6 to save an excel file the creator of that file has ownership of the created file. This allows for the creator of the file to delete the file.
I have an application I've written that saves an excel file to a folder whose permissions for the "users" group is read and write only (no modify).
However, since the particular user was logged into the machine they will now have ownership of that file, and if they wanted could give themselves modify privelidges.
This is not good as this data needs to never be deleted once it is created by the VB6 application.
I've tried everything to get around this. Changing the ACL and ACE. Trying to remove the user who created the file as the "owner" (unsuccessfully). I've also tried to open excel as an admin, that way when the file is saved the admin is the owner (couldn't use the getobject() when I did this)
Please Please Please someone help me. I'm going insane here!
I've been working on this issue for 2 days now and can not come up with a good solution, please someone point me in the right direction...
When using VB6 to save an excel file the creator of that file has ownership of the created file. This allows for the creator of the file to delete the file.
I have an application I've written that saves an excel file to a folder whose permissions for the "users" group is read and write only (no modify).
However, since the particular user was logged into the machine they will now have ownership of that file, and if they wanted could give themselves modify privelidges.
This is not good as this data needs to never be deleted once it is created by the VB6 application.
I've tried everything to get around this. Changing the ACL and ACE. Trying to remove the user who created the file as the "owner" (unsuccessfully). I've also tried to open excel as an admin, that way when the file is saved the admin is the owner (couldn't use the getobject() when I did this)
Please Please Please someone help me. I'm going insane here!