I have an Access Database. For some reason when we moved from 2000 to 2003 the system launches a query when opening the form. It acts like there is a filter or sort on the table. It will launch a query (who knows what) when opening or performing a Find Record search. Each time the person tries to search it relaunches the query.
A compact and repair fixes the problem and the database will run fine. However, there is something else a user must be doing that puts the filter/sort back on. Any ideas on where to find this problem and how to fix it?