Forum Discussion
Access slow to open
CustomMadeDB At first ... i would go with the specs..no matter if one laptop is 10 years old and the other is brand new....an i7 from the past would outperform some low end new processors and then there other things that make the difference...like single thread performance.
This belongs to the CPU area.
Moving to memory...well here things are better in terms that newer rams are usually better...not dramatically especially for laptops but ...here you want a good scan with MemTest+ to ensure they are are error free
Now its time for the HDD....in these days if you don't have SSD or better M2 you are slow...no matter what....HDTune should give you a first glimpse of what performance differences you have
OS ....laptops some times have some strange issues with drivers..while they share the most with desktops tiny changes in firmware make the drivers a big case...check for latest BIOS + drivers
Antivirus & background process....well probably here is the culprit...make sure that paths to Office are excluded and for testing just try to disable everything...
Since you already spend 14 hours i would propose the fastest way to check....
1st check memory
2nd check HDD ...if you find that one drive reads/write in the 400-500 Mb and the other in 30-50Mb/s you know that you are comparing oranges to apples.
3rd find some stressing utility for CPU (IntelBurn)
4th take a good backup of your system
5th ...don't reinstall or repair Windows...just install fresh..clean the drive...let it update and find whatever it needs...don't install ANYTHING extra
6th just install Office....on default...preferably 32bit if you are mixing development.
Report back
P.S. curious how you develop Access on Laptop.. i have tried it a couple of time and it was a pain.....nothing beats a big screen and a wireless mouse ....i am also a Ms Access developer-freelancer ...cheers from Greece
@CustomMadeDB To add a crucial mid step ...just before step 5 ...make sure you stripped you Laptop from anything extra...USB drive,printers,NAS....
When you start step 5 it will be only the Laptop ,the charger and the USB stick with the Windows 10 installation media + Office and maybe some test LOCAL Access databases.
It would be a good idea to also connect the laptop to the router directly via cable NOT wifi.
Thanks for taking time to give me such a detailed response. One thing I don't understand is, if the access files can open in 1 or 2 seconds when opened from within the Access program, then I doubt that there is an HDD or processor problem. It is only when I try to open an Access file by double clicking it in the Windows Explorer list, or when selecting it from right-click on the task bar that it takes ages to open. One way takes 2 seconds the other ways can take up to 2 minutes, and never less than 20 to 30 seconds. I have a feeling it is a Windows problem, in which case totally reinstalling windows (clean), as you suggest, is probably the answer.
Re the laptop use for DB development, I have never found this to be a problem, as most of my clients use a laptop or small screen device some of the time, so I tend to format all of my systems for that format. It just means that when they use larger displays, the have a lot of spare space on the right.
I do also use an attached display on my laptop in my office, so that helps. What sort of systems do you develop? Mine are all small-business related; marketing, invoicing, production control, purchase orders, etc.
- Well ... i just tried to cover every single option...since you already have spend too much time without results which points to "strange"...
As for my systems i develop...lets say i develop pretty much everything..."whatever the client wants"
I have a great deal of experience in enterprise scoped applications as i worked for many years for a big company which used Access as its heart of IT...a huge Access application a mix between ERP & MRP....too many years in maintaning,optimizing,expanding, adding features , connections with 3rd party ERP....
