Setting rowsource of chart dynamically, with user security in place

T

Tony M

Hi. I have a report that I launch in preview mode from a button on a
form. I have a chart embedded in the report that I wish to update
dynamically, based on values entered on this form. I have seen the MS
Knowledge Base article Q209993 that describes how to go about this.
Basically, the report is placed in design mode, the RowSource property
of the chart is set, then the report is saved with the new RowSource
value and previewed.

This method works fine for now. However, in the future, I would like
to place user level security on the database, with only users places
in an "administrators" group being able to change this (or any) report
in design view. Is there another way of accomplishing this task, or
would user security even pose a problem?

Tony
 
Top