password modules

N

Newbie

Hi,
I have a database that I can't change to and mde because certain parts of
the code to do with printing need to be able to open reports in design mode.

How can I set passwords on the code so that people can't change it?
 
G

Greg Kraushaar

You need to set user level security
This is NOT a simple topic.
Refer to Ken Getz or some other text that goes into it thoroughly.

Your end goal will be that the User Admin can open and run the
database, and all the objects in it, but doesn't have permission to
change any design.

Are you absolutely sure you need to open the report in design mode.
I have been developing in MSA for about 15 years now, and haven't had
the need yet. you can change controls locations, visibility, shape,
colour, captions etc without having the form in design mode. You just
can't save the changes.

About the only reason I ever had was to make print control changes, &
I managed to convince the customer he needed to standardise his
printer collection.

Regards Greg Kraushaar
Wentworth Falls Australia
(Do not email - the reply address is a Spam spoofer)
(If you really must, remove all UCase and numbers)
 
N

Newbie

Thanks for this but what I have is a label that the user can choose where
she wants it printed out i.e on which dept printer. The label is a custom
paper size - I can set everything for the printer except the paper size so
depending on which location the user chooses (if it is not the one for which
I saved the report) it comes out on Letter size paper.
I set up 4 printers and set all the defaults to the correct papersize but
this didn't make any difference. The only way I have found to do it is by
using the PrtDevMode and this , I believe, is only availabe at design time.

Do you have any other suggestions that will help me get round this problem?
 
Top