Disable Filter Functionality / Massive slowdowns

[BCullenward]

Is there a way to disable the filter feature in MS Access? I have several users that use the filter to find a single record when I've repeatedly told them that using CTRL-F is faster and less of a strain on network traffic.

I'm trying to eliminate all possible causes of a massive slowdown that occurs everyday at roughly 10-noon. There are several ODBC timeouts (even after including some code to have it attempt to retrieve the data 3 times prior to it allowing the timeout message to pop-up).

I have removed all linked tables/queries that are not needed and the database has been rebuilt. Compressed the database is under 2 megs and the SQL Server backend is on it's own server where the same queries return instant results.

 

[FlyerMike]

One of the form properties is AllowFilters. If you set it to False, users should not be able to filter the form.

As far as queries and tables....I don't think you can stop them, unless you modify the menus and toolbars within the application.

 

[ghudson]

You need to remove the standard tool bars and menu bars and also the right-click option in your application. Search around the Code section of the forum for I posted some code that will do all of that. The users should never have access to the database window or the built-in tool bars.