Forum Discussion
Access slow to open
it seems that the cpu usage was the problem, the default settings was using 2 CORES out of 6 Cores (i5 8400). after changing to one and retain the memory usage to 4GB. my emulator is still smooth and my accdb problem is gone. So win win situation 😄
I wanted to provide an update on my original post.
Reading through this thread I noted that the original problem for the poster was that he experienced different speeds opening an Access Database depending on the method used to do so.
I tried opening Access first, then opening the database from within Access. The first time around, it did what I expected which was that it closed the current database and opened the second one as the only one.
I then opened a new instance of Access from the Start Bar and opened the second database from the new instance while the first instance still had the first database open. My second database opened immediately.
So for me, the issue is now resolved but it does seem odd that "how you open a database" makes a difference in performance when no other Office product has that same issue. For example, opening multiple Word, Excel, Publisher, or PowerPoint files from Explorer doesn't seem to have a performance hit yet Access seems to experience a very serious performance hit.
Take care.
StevenED1964
I think this issue that you have experience is from the office update from last week of Jan 2022 or first week of Feb 2022.
Wherein some of the access accdb runs in the background in the first run,it got recently fix update last week.
Hopefully your office got the latest update and fix it 😉Regarding with the emulator that I have a problem before was Bluestacks and I switch to LDPlayer to solve my issue 🙂
Apologies if you have already mentioned this but are you using a split database? If so, your second instance may be using the original as a persistent connection which would definitely improve performance.
