I know there are a lot of articles with advice about faster performance in Access, but this is an intermittent problem. Even when using very simple queries, this problem still occurs.
We have several Access forms which, at times, take as long as 2 minutes or more to load. Normally, they take about 5 seconds to load on average.
The database file has links to tables that are located on a network drive. The database itself is on the local hard drive.
The only thing I can think of is that some forms have lookup tables and multiselect dropdown lists. I am considering the possibility that the solution is here (http://support.microsoft.com/kb/918575
) but I have not tried this yet, and thought it may have been fixed in the latest service pack, so was wondering if there are any other possibilities.