Prevent from saving sort order.

  • Thread starter Thread starter Marek F.
  • Start date Start date
M

Marek F.

Hello,
I have a split front/back end with locked .mde front (no access to db
window, security implemented, shift key locked etc.).
In my front end a user can open a query and sort it any way he/she likes it
(that's what I want).
How can I prevent a user from saving those sorting changes?
I want to avoid creating a form for each query...( I know I can establish my
own sort order upon opening a form)
TIA
Marek
 
There's a "modify design" permission under Tools/Security/User and group
permissions. Uncheck this box for the relevant user group. I haven't
tried this but I'm betting this will do it.
 
Why are you allowing the user anywhere near the queries?

Replace the code with something that opens a datasheet form instead.
 
Allen Browne said:
Why are you allowing the user anywhere near the queries?

Replace the code with something that opens a datasheet form instead.
Click to expand...

Because I do not have to come up with a form for each query....
What is so bad allowing users access to queries if they are locked out of
data edit permissions?
Thank you for your response.
Marek
 
Back
Top