Temporarily grant read permissions to a folder on Windows Server 2008 using Access 2010 VBA
Posted on 2012-09-20
Hi. We have an Access 2010 database that gives users a link to click to view files in a folder on our network called PDF_Files. The server where the folder is located has Windows Server 2008.
The data in the database is protected in such a way that users can only view records that they are allowed to see (we have a SQL Server backend) and therefore will only be able to view files in the PDF_Files folder that they are allowed to see.
We recently protected the PDF_Files folder so no users can get into the folder directly. Previously it was wide open. Now the link in the database is not allowing them to view the PDF files.
Is there a way, using VBA, that I can temporarily allow permissions to view files in the folder for a user only when they are coming from the database and then take those permissions away again after the file opens?