Hello,
I have created an Access database application that takes about a minute to load. That database consists of 84,000 companies and 265,000 contacts. Currently, the record source of my main form is a query. As it slowly starts up, I can see that it is running my query. Once I let the program start up, everything runs very quickly. I'm also able to shut down and restart the program with no wait time. Every time I restart my computer, and start the program, it takes a minute again. So there is the problem.
I am fairly new to Access. Do you know of anything that I can do differently to avoid the long startup? My main form has data from multiple tables on it, which is why I think i have to have the query set as the record source (Correct me if I'm wrong). I'm guessing that Access caches the query data somewhere since it only opens slow the first time after restart. Is there a way to have Access run the query in the background when the system starts? Thanks for any advice you might be able to provide.
Best regards,
Pat
Start Free Trial
