S
Sue
I have written a custom application on a secured
database. User Program has all rights and user
ReportUser has limited rights.
User Program is and must be the owner of all reports that
we write so users cannot change them. In order to change
the group levels (sorts) and filter data for a report,
I must open it in design view and leave it open until the
Preview, Print, Export or whatever is finished.
If I am signed in as user Program, Access AUTOMATICALLY
saves the design changes to the actual report. This is
no big deal since I can save the original group levels
and reset them.
If I am signed in as User ReportWriter, Access ALWAYS
prompts me to save the report to a new name. I cannot
figure out how I can close the DESIGN view via code and
leave the preview open or close it when the preview is
closed automatically with the acNoSave option invoked. I
can run a DOCMD.Close in the Form Activate area
of the calling form and it runs through the code but
doesn't close anything. I have been as far as copying the
report to a temp name so the ReportWriter user is the
owner, running everything and trying to Delete the temp
report, but it errors because it is supposedly open. The
funny part is.if I open the design view on the task bar,
there no design area for the report or even any close
buttons at the top. Like the DoCmd close works partially?
Any ideas would be greatly appreciated.
database. User Program has all rights and user
ReportUser has limited rights.
User Program is and must be the owner of all reports that
we write so users cannot change them. In order to change
the group levels (sorts) and filter data for a report,
I must open it in design view and leave it open until the
Preview, Print, Export or whatever is finished.
If I am signed in as user Program, Access AUTOMATICALLY
saves the design changes to the actual report. This is
no big deal since I can save the original group levels
and reset them.
If I am signed in as User ReportWriter, Access ALWAYS
prompts me to save the report to a new name. I cannot
figure out how I can close the DESIGN view via code and
leave the preview open or close it when the preview is
closed automatically with the acNoSave option invoked. I
can run a DOCMD.Close in the Form Activate area
of the calling form and it runs through the code but
doesn't close anything. I have been as far as copying the
report to a temp name so the ReportWriter user is the
owner, running everything and trying to Delete the temp
report, but it errors because it is supposedly open. The
funny part is.if I open the design view on the task bar,
there no design area for the report or even any close
buttons at the top. Like the DoCmd close works partially?
Any ideas would be greatly appreciated.