Prevent from saving sort order.

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
 
S

Sirocco

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.
 
A

Allen Browne

Why are you allowing the user anywhere near the queries?

Replace the code with something that opens a datasheet form instead.
 
M

Marek F.

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
 
Top