MDE file restrict filter usage.

[lawsonium]

Hi,

I have an MDE database and the key form relies quite heavily on a filter. The only trouble is the user can right click on the form and select to turn the filter on and even change it. I can see why this is possible even though the database has been converted to an MDE but it is something I would like to have disabled. Any ideas?

Thanks,

Matt.

 

[allan57]

Checkout the 'AllowFilters' property in VBA Help

 

[lawsonium]

Yes, I'm aware of that. You need "AllowFilters" to be set to TRUE before the required filter will be implemented. If it is set to FALSE, not even the filter you require will be applied. I just want to stop the user applying thier own filter or turning the filter off.

Thanks.

 

[allan57]

Setting the AllowFilters property to No does not affect the Filter and FilterOn properties. You can still use these properties to set and remove filters.

 

[lawsonium]

I take it that FilterOn is set only through VBA as it isn't in the properties list?

Thanks,

Matt.

 

[Rich]

Set the Allow short cut menu to no