In Access 2007 or 2003, I'm using the FSO for moving files. I need the FSO to have permissions which the logged on user does not have.
In this case, the machine is a server and there is no human user, Access is running as a Scheduled Task under a less privileged user account. This is all fine but now I need to pluck and place files into area's where I don't want this user account to have explicit permissions.
I'm kludging it right now by placing a NET USE statement in the code with a higher privileged user's credentials, just prior to Setting the FSO. With the Use statement in place, the fso all of a sudden can access these files (I'm not mapping a drive, just running the NET USE which appears to cache credentials for the entire console session).
So what I'd like to do is have that be a little more narrowly focused, ie permissions given directly to the fso object.
Is this possible, or does anyone have an other suggestions on how to accomplish this?
(I've added this to the .Net area because this app is a prototype and will eventually be done in .Net)