Not sure where to ask this one, but you guys have been EXTREMELY helpful in the past so I thought I'd start here.
I've got an Access DB, that runs some queries and some VBA and merges about 25 files on-demand for me. Those files that it merges are MSWord documents that are stored on a network share. I'm having an issue that one of my users, instead of running the VBA from Access as they are supposed to, have gone into the files themselves and made some changes to the MSWord files. I can't have my end-users making changes to my original files because when they do, the Access VBA breaks and doesn't run correctly. I have some bad feelings about why this user is doing this, but that's not a discussion for here.
I understand the user MUST have access to the MSWord files to be able to run the VBA, but is there a way I can make sure they cannot access the files directly?
I've got an Access DB, that runs some queries and some VBA and merges about 25 files on-demand for me. Those files that it merges are MSWord documents that are stored on a network share. I'm having an issue that one of my users, instead of running the VBA from Access as they are supposed to, have gone into the files themselves and made some changes to the MSWord files. I can't have my end-users making changes to my original files because when they do, the Access VBA breaks and doesn't run correctly. I have some bad feelings about why this user is doing this, but that's not a discussion for here.
I understand the user MUST have access to the MSWord files to be able to run the VBA, but is there a way I can make sure they cannot access the files directly?