locking view design

[steve111]

hi,

is it possible to lock the " view design" the user at present could run a query and the view the design and change it

this would also include forms

thanks
steve

 

[CJ_London]

with regards forms, create an mde or accde file

difficult with queries (or tables), best option is to hardcode the queries in VBA and then they will be protected the same as forms - and put the tables in a separate backend which is password protected

 

[pbaldy]

Another option (though I would still distribute an mde/accde), if you have control, is to force users into runtime mode using the command line switch. Most of my users only have the runtime version anyway, but I use the runtime switch in my version control utility to force regular users into that mode too.