Can a Jet Report be cleared of data on opening forcing the user to refresh?
My concern is that User A runs a report on a shared drive. User B later opens that same report. User B does not have permission to run the report, but the values are still there from the last run.
Thanks,
Tim
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Tim,
If you remove +Values and +Lock from the report, then the Jet functions will refresh when you open the workbook (although you could still glimpse some numbers before they got recalculated!).
Really the better solution for this is to set permissions on the shared drive or the folder that contains the sensitive reports so that only those with permissions can access those folders and the users who have access are aware of this fact. You wouldn't leave print outs of your company's sensitive financial data lying around for anybody to find, so don't do the digital equivalent when using shared drives.
Regards,
Hughes -
Jet Reports Historic Posts Thanks Hughes, but that isn't working for me. When I take out the +Values from the report, it won't run at all. If I change the "Auto+Hide+Values" to "Auto+Hide"I get a Jet error message saying, "You are not licensed to design reports. If you are a licensed Report Viewer, please tell your Report Designer that "Auto+Hide+Values" or Auto+Hide+Lock" must be in cell A1 of at least one worksheet of the report and that the report must be saved in Report Mode." I am a Report Designer and it runs just fine if I add either Lock or Values back in.
Thanks,
Tim -
Jet Reports Historic Posts Tim,
You must have some mismatch between your Jet license and your Excel username. Check the names of the licensed designers on your Jet license and check your Excel username (Excel Options -> General -> User name). Your Excel username must match one of the named designers on your Jet license or else you will get the message you are seeing when trying to design reports.
Regards,
Hughes
Please sign in to leave a comment.