Server Filter saved

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is an Access ADP form where I would like to make sure that when the form
is closed that nothing is saved in the property Server Filter.

I have had users close the form and then return to find out that the records
are being filtered with an entry in the Server Filters property.

It was my understanding that this could only be saved in design mode and
these users are never in design mode.

Is there way to turn this feature off.....it is driving me to you know
what....

Thank you for any help in advance.
 
C> This is an Access ADP form where I would like to make sure
C> that when the form is closed that nothing is saved in the
C> property Server Filter.

C> I have had users close the form and then return to find out
C> that the records are being filtered with an entry in the
C> Server Filters property.
C> Is there way to turn this feature off.....it is driving me to
C> you know what....

1. put serverfilter="" in the onclose event for the form.
2. if (1) does not help, install the file as readonly for the users. If they
have full Access, they will have a warning on opening - a minor
inconvenience. If runtime-only Access, then no warning.


Vadim
 
or?

3. don't use server filters. They will hang you eventually one way or
another. Instead, use stored procs as your forms record source. Roll your
own ad-hoc query tool if you must.
 
Back
Top