In Access 2010 the user can kick off a report. At the same time this will run a second report.
What I want to do is save the second report to a network folder. The user does not have permissions to this folder.
how can I save a file with different username and password.
.
the reality. At the moment a customer service rep runs a report and then runs a second report. The second report is for the finance department. The customer service rep emails the second report to the finance department or saves it to a folder that anyone can get too. We are trying to lock down the folder permissions. There is no reason a customer service rep should be able to see all the finance reports and files.
Make sense?
thanks
Rob