Lock a query for editing - run only

[paul83]

Hi All



I have had a search through but I was unable to find anything on this subject, and also unable to find using Google

I am working with quite a large dataset, and the data is run in different queries each day by individual managers. However; these managers are....pretty useless when it comes to designing queries. So it is causing a lot of problems.

One option is to run all the queries myself, however I don't have enough time to do this.

Is there a way that anyone knows where I could create the query, lock it for editing and give read/run only access to the managers. So they can still click it and run it, so they can print it, but not edit it.

Or any other outside the box ideas, perhaps scheduling the specific queries to run at a certain time each day and print?

Thanks in advance

[ranman256]

It's a param...

if IsManager() then 
   VParm = acedit
else
   VParm = acReadonly
endif 

docmd.openquery "qsMyQry", ,vParm

[paul83]

Thanks for your reply; so if we look to remove access from the 'back' of access; only allow through the front design; then have a dashboard with buttons linking to the queries, and apply this - is that the best action you'd say on this?

Thanks again for your response

[ranman256]

yes. only you would know how to calculate IsManager.