I have been dealing with this database issue for months, ever since I upgraded the users from Access 97 to 2007.
I have tried every suggestion under the sun to try to speed up the database opening queries, forms, and reports:
*created a brand new database and imported all objects into it
*made sure none of the objects in question are using Dlookup function
*reduced # of command buttons on forms
*removed unnecessary macros from reports
*went through each form and report and deleted unneeded objects
*compacted and repaired db
*created relationships for 12 tables
*ran db analyzers and let it add indexes on tables and added Option Explicit statement on forms
*downloaded and installed Office 2007 updates including Offc 2007 SP2
*ran compact and repair again
*as last resort, I converted the 2007 db to 2003 format
The db is on the hard drive on a PC - the PCs are not old and have 2GB memory - and another PC shares the C: drive from the main PC to access the database. The main PC opens the objects quickly, but the seconday db takes as long as 10 minutes just to open 1 form; says it's running a query. If the user tabs from one field to another, it stops and says "running query" again. Trying to do a simple search on a field takes up to 5 minutes.
I looked at the answers given so far, and they either don't apply to me or I've already tried them. Can anyone else tell me what to do? The users are getting restless. They can't be taking 10 minutes to open a report when they have 20 to open every day.